Is there a MySQL command to convert a string to lowercase?
UPDATE table SET colname=LOWER(colname);
Yes, the function is LOWER() or LCASE() (they both do the same thing).
For example:
select LOWER(keyword) from my_table
UPDATE table SET colname=LOWER(colname);
Yes, the function is LOWER() or LCASE() (they both do the same thing).
For example:
select LOWER(keyword) from my_table