uppercase to lower case mysql query

uppercase to lower case query

To select all the data from the above table and convert it to lower case you would do this:

SELECT LOWER(name) FROM mytable

This would return this:

+----------------------------+
| LOWER(name)                |
+----------------------------+
| lorem ipsum dolor sit amet |
| ut purus est               |
| leo sed condimentum semper |
| donec velit neque          |
| maecenas ullamcorper       |
+----------------------------+