mysql lower() function example

1
SELECT LOWER('SOME TEXT...');

1
SELECT LOWER(`column_name`) FROM `table_name`;

1
SELECT LOWER(`name`) AS `Lowercase names` FROM `users`;