UPPER
()
UPPER(str)和UCASE(str)函数用于将字符串转换为大写形式,例如:
SELECT UPPER('MySQL字符串函数') AS str1, UCASE('MySQL字符串函数') AS str2;
str1 |str2 |
--------------+--------------+
MYSQL字符串函数|MYSQL字符串函数|
()UPPER(str)和UCASE(str)函数用于将字符串转换为大写形式,例如:
SELECT UPPER('MySQL字符串函数') AS str1, UCASE('MySQL字符串函数') AS str2;
str1 |str2 |
--------------+--------------+
MYSQL字符串函数|MYSQL字符串函数|