scott532 Posted May 14, 2006 Share Posted May 14, 2006 Hi,I want to take the usernames in a table and change them all into lowercase. Is there a way to do that aside from doing it by hand?Thanks,Scott G. Quote Link to comment https://forums.phpfreaks.com/topic/9632-making-things-lowercase-in-mysql/ Share on other sites More sharing options...
Zane Posted May 14, 2006 Share Posted May 14, 2006 [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']UPDATE[/span] tablename SET yourfield [color=orange]=[/color] LOWER(yourfield) [!--sql2--][/div][!--sql3--] Quote Link to comment https://forums.phpfreaks.com/topic/9632-making-things-lowercase-in-mysql/#findComment-35601 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.