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?
UPDATE table SET colname=LOWER(colname);
Yes, the function is LOWER() or LCASE() (they both do the same thing).
select LOWER(keyword) from my_table