mysql string to lower case code example

Example 1: mysql to lowercase

+--------------------+
| LOWER('ATTENTION') |
+--------------------+
| attention          |
+--------------------+

Example 2: how to use lower case in mysql

UPDATE my_table SET my_column = LOWER(my_column)