D/MySQL
[MySQL]UPPER()
yeon.Biju
2020. 6. 18. 10:14
MySQL 문자열 함수와 연산자
UPPER()
-
UPPER(str)
의 형태
Returns the string str with all characters changed to uppercase according to the current character set mapping.
mysql> SELECT UPPER('Hej');
+--------------+
| UPPER('Hej') |
+--------------+
| HEJ |
+--------------+
1 row in set (0.00 sec)
UCASE()
[MySQL]UCASE()
MySQL 문자열 함수와 연산자 UCASE() - UCASE(str) 의 형태 UCASE() is a synonym for UPPER(). UCASE() used within views is rewritten as UPPER().
webobj.tistory.com
LOWER()
[MySQL] LOWER()
MySQL 문자열 함수와 연산자 LOWER() - LOWER(str) 의 형태 Returns the string str with all characters changed to lowercase according to the current character set mapping. The default is utf8mb4. (MyS..
webobj.tistory.com