How to convert the XenForo username to lowercase.

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

SQL:

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

SQL:

UPDATE xf_user 
SET username = CONCAT(UPPER(SUBSTRING(username, 1...

Click to expand...

Read more

Читать далее...