MySQL 8.1
UCASE(str)Parameters
- strVARCHAR
- Source string
Return value
A string in uppercase
Examples
A string in uppercase
MySQL 8.1
SELECT UCASE('SQL Academy') AS upper_case;Capital first letter
MySQL 8.1
SELECT good_name,
CONCAT(
UCASE(LEFT(good_name, 1)),
SUBSTRING(good_name, 2)
) AS capitalized
FROM Goods
LIMIT 5;