Posts tagged: MYSQL to UPPER CASE and LOWER CASE

MYSQL to UPPER CASE and LOWER CASE

By , 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);

Thomas Challenger Thomas Challenger