How to convert the XenForo username to lowercase.

[Thangvip9x]

Thangvip9x submitted a new resource:

How to convert the XenForo username to lowercase. - Convert the XenForo username to lowercase.

Today, I will show you how to convert usernames to lowercase. Please go to phpMyAdmin > SQL and run this command

UPDATE xf_user SET username = LOWER(username);

View attachment 303635
Or use this command if you only want to uppercase the first character of the username

UPDATE xf_user 
SET username = CONCAT(UPPER(SUBSTRING(username, 1, 1)), LOWER(SUBSTRING(username, 2)));

View attachment 303636...

Read more about this resource...