Editing all data in a given column

Databases
1

I have a keywords column that has mixed capitalization of the words. I would like to go through each row and covert all to lowercase. Is this possible with just mySQL? Or do I need to use a php script to read the row, make the change, then reinsert the data back in?

Thanks!

2

lower

3

yes

:slight_smile:

4 
UPDATE tblName
SET colName = LOWER(colName)