MySql Query to Change a lower case to upper case

If you want to update:

UPDATE my_table SET my_column = UPPER(my_column)

mysql sql string

Have a look at using UPPER

Returns the string str with all characters changed to uppercase according to the current character set mapping.

From the LINK

UCASE() is a synonym for UPPER().

Have a look at this example

SQL Fiddle DEMO

mysql sql string

Use upper() or UCASE()

Example:

SELECT UCASE(columnName) FROM `table_name` SELECT UPPER(columnName) FROM `table_name`

Updation

UPDATE table_name SET field_name = UPPER(field_name)UPDATE table_name SET field_name = UCASE(field_name)