Jump to content


Photo

Making things lowercase in MySQL


  • Please log in to reply
1 reply to this topic

#1 scott532

scott532
  • Members
  • PipPip
  • Member
  • 14 posts
  • LocationSanta Barbara, CA. (USA)

Posted 14 May 2006 - 01:49 AM

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.

#2 Zane

Zane
  • Administrators
  • Advanced Member
  • 4,134 posts

Posted 14 May 2006 - 02:00 AM

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']UPDATE[/span] tablename SET yourfield = LOWER(yourfield) [!--sql2--][/div][!--sql3--]

btn_donate_SM.gif Want to thank me? Contribute to my PayPal piggy-bank
 

172938.png




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users