mysql lowercase in where clause 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)