you are at Encyclopedia of SQL >> LCASE()
LCASE(`column_name`)
Function converts given text string lowercase.Syntax
SELECT LCASE(`column_name`)
FROM `table_name`
Example
Display all surnames lowercase
| name | surname | age |
|---|---|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT LCASE(`surname`)
FROM `people`
result
| LCASE(`surname`) |
|---|
| kowalski |
| janik |
| nowak |
