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