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?
SET colName = LOWER(colName)