Joe Link Well-known member Jul 7, 2015 #1 What's the best way for me to get a list of users with usernames over 14 characters?
P Paul B XenForo moderator Staff member Jul 7, 2015 #2 There is no option to do that in the front end or ACP, you would have to interrogate the database directly using LENGTH. Code: SELECT username FROM `xf_user` WHERE LENGTH(username) > 14 Upvote 0 Downvote
There is no option to do that in the front end or ACP, you would have to interrogate the database directly using LENGTH. Code: SELECT username FROM `xf_user` WHERE LENGTH(username) > 14
