UPPER
Converts all letters of a string to uppercase.
MySQL 8.1
UPPER(str)Parameters
- strVARCHAR
- Source string
Return value
A string in uppercase
Examples
String in uppercase
MySQL 8.1
SELECT UPPER('Hello World');Status in uppercase
MySQL 8.1
SELECT member_name,
UPPER(status) AS status
FROM FamilyMembers;Details
Works with Cyrillic too. The synonym is UCASE. The function does not change binary strings (the BINARY type, the result of CHAR without USING): convert them to text first with CONVERT(value USING utf8mb4).