Is there a MySQL command to convert a string to lowercase?

Question

I have a MySQL database of keywords that are presently mixed-case. However, I want to convert them all to lowercase. Is there an easy command to do this, either using MySQL or MySQL and PHP?

Answer 1

UPDATE table SET colname=LOWER(colname);