MySQL lowercase and uppercase

If you want to convert strings to lowercase in MySQL you can use LOWER() function like this:

SELECT LOWER('My String');


SELECT id, category, LOWER(title) FROM articles;


SELECT id, category, title FROM articles WHERE LOWER(title) = 'red';

It is also possible to convert all records of selected field to lowercase:

UPDATE articles SET title=LOWER(title);