View Full Version : Capitalize all values in column

04-08-2013, 04:56 PM
I've had a fair look around the net and these forums, but haven't had much finding an answer to this problem. I have column in a table that's defined as a primary key, varchar, 3 max. I need to capitalize all the letters (not just the first leter) in this column. I wonder-- is there a MySQL query I could use to do this?

04-08-2013, 06:45 PM
Sure is; you can use either UCASE() or UPPER() functions. Both of them should return the results of the string in complete upper case.

04-09-2013, 07:17 PM
I'm actually not trying to return the values in uppercase, I'm trying to manipulate the data currently in the table so all the values in one column are in ALL CAPS.

Thanks again for the help!

04-09-2013, 07:21 PM
Same principle, use an UPDATE statement with it.