UPPER() FUNCTION
The MySQL UPPER function is used to convert all characters in the specified string to uppercase. The various versions of MySQL support the UPPER function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23.
Syntax:
UPPER( string )
UPPER( string )
UPPER( string )
Parameters:
string: It is used to specify the string to modify.
Example:
mysql> SELECT UPPER ( ‘hello world 123’ );
mysql> SELECT UPPER ( ‘hello world 123’ );
mysql> SELECT UPPER ( ‘hello world 123’ );
Output:
'HELLO WORLD 123'
'HELLO WORLD 123'
'HELLO WORLD 123'
Explanation:
All the letters are converted to uppercase.