1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Search for usernames over character limit?

Discussion in 'XenForo Questions and Support' started by Joe Link, Jul 7, 2015.

  1. Joe Link

    Joe Link Well-Known Member

    What's the best way for me to get a list of users with usernames over 14 characters?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    There is no option to do that in the front end or ACP, you would have to interrogate the database directly using LENGTH.
    SELECT username FROM `xf_user` WHERE LENGTH(username) > 14
  3. Joe Link

    Joe Link Well-Known Member

    Thanks, that's what I figured :)

Share This Page