Comments (0)

By admin, September 28, 2011 3:09 PM

How to convert MYSQL Columns to Upper Case and Lower Case

SELECT LOWER(name) FROM mytable
SELECT UPPER(name) FROM mytable

UPDATE mytable SET name = LOWER(name);
UPDATE mytable SET name = UPPER(name);