If you want to convert strings to lowercase in MySQL you can use LOWER() function like this:
SELECT LOWER('My String');
or
SELECT id, category, LOWER(title) FROM articles;
or
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);