how to specify a character is capital in mysql code example

Example: mysql convert column to uppercase

UPDATE my_table SET my_column = UPPER(my_column)