jesteś w Encyklopedii SQL >> UCASE()
UCASE(`column_name`)
Converts given text string to uppercaseSyntax
SELECT UCASE(`column_name`)
FROM `table_name`
Example
Display all surnames uppercase
| name | surname | age |
|---|---|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT UCASE(`surname`)
FROM `people`
result
| UCASE(`surname`) |
|---|
| KOWALSKI |
| JANIK |
| NOWAK |
