Search code examples
mysqlregexlowercase

regex in mysql update statement, convert to lowercase

i'd like to update a table field in my mysql data base and convert all links to lowercase, e.g.

to convert: 

http://www.domamain.com/MyLinks/News/FileName.html
to 
http://www.domamain.com/mylinks/news/filename.html

Can this be done?

Thanks

Solution

  • You can convert an entire column to lowercase with the LOWER() function

    UPDATE mytable
SET url = LOWER(url)

    It seems that you can't do regular expression replace in MYSQL though: How to do a regular expression replace in MySQL?