Sometimes we need to convert upper case to lower case, for example, x-cart, by default, its category and product URL shows as a category or product name. if a category or product name has an upper case, then its related URL also shows upper case. Can we convert URLs from upper case to lower case?
The answer is yes, simple way is we can log in PHPMyAdmin, and use MySQL command to do this:
UPDATE table SET colname=LOWER(colname)
UPDATE babyname SET comment = LOWER(comment)