Upper()将文本转换为大写 ;
SELECT
AREAR_CODE, UPPER(AREAR_CODE) AS AREAR_CODE_UPPER FROM net_resource_msg_log LIMIT 2;
I Like English --> I LIKE ENGLISH
Left(str, str_len) 返回串左边的字符: str 表示选取的列名,str_len从左边截取的长度 ;
SELECT
AREAR_CODE, LEFT(AREAR_CODE, 2) AS AREAR_CODE_left_len_2 FROM net_resource_msg_log LIMIT 2;
Locate() 找出串的一个子串的索引位置,位置索引范围:[1, len(字符串长度)]
AREAR_CODE = '阳光'
SELECT
AREAR_CODE, LOCATE('光', AREAR_CODE) AS AREAR_CODE_SUB_STR FROM net_resource_msg_log LIMIT 10;
Lower() 将串转换为小写
SELECT
AREAR_CODE, LOWER(AREAR_CODE) AS AREAR_CODE_UPPER FROM net_resource_msg_log LIMIT 2;
I Like English --> i like english
LTrim() 去掉串左边的空格
SELECT
AREAR_CODE, LTRIM(AREAR_CODE) AS AREAR_CODE_UPPER FROM net_resource_msg_log LIMIT 2;
I Like English --> I Like English
Right(str, len) 返回串右边的字符
# 取字符串右边的两个字符
SELECT
AREAR_CODE, RIGHT(AREAR_CODE, 2) AS AREAR_CODE_NEW FROM net_resource_msg_log LIMIT 2;
I Like English --> sh
RTrim() 去掉串右边的空格
SELECT
AREAR_CODE, RTRIM(AREAR_CODE) AS AREAR_CODE_NEW FROM net_resource_msg_log LIMIT 2;
I Like English --> I Like English
SubString(substring, substring_index) 返回子串的字符
SELECT
AREAR_CODE, SUBSTRING('Like', 3, 5) AS AREAR_CODE_NEW FROM net_resource_msg_log LIMIT 2;
I Like English --> ke
Upper() 将串转换为大写
SELECT
AREAR_CODE, UPPER(AREAR_CODE) AS AREAR_CODE_NEW FROM net_resource_msg_log LIMIT 2;
I Like English --> I LIKE ENGLISH