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. 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--] 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
Archived
This topic is now archived and is closed to further replies.