Simple way to convert Upper Case to Lower Case via MySQL

Sometimes we need to convert upper case to lower case, for example, x-cart, by default, its category and product url shows as category or product name. if a category or product name has upper case, the its related url also show upper case. Can we conver url with upper case to lower case?

The anser is yes, simple way is we can login phpmymin, and use mysql command to do this:

UPDATE table SET colname=LOWER(colname)

UPDATE babyname SET comment = LOWER(comment)