MySQL-字符串函数

# 字符串函数
SELECT * FROM employee
SELECT CHARSET(job) FROM employee -- 返回utf8

SELECT CONCAT(`username`, ' 工作是 ',job) FROM employee -- 拼接字符串

SELECT INSTR('ybjandcyt','cyt') FROM DUAL -- dual是亚元表，用作测试，返回cyt出现的位置7

SELECT UCASE(username) FROM employee -- 转成大写,lcase小写

SELECT LEFT(username, 2) FROM employee -- 从左取两位,right从右边取

SELECT LENGTH(username) FROM employee -- 按照字节返回长度

SELECT username, REPLACE(job,'研究员', '小牛马') FROM employee -- 查找job，若为研究员就替换为小牛马

SELECT STRCMP('ybj','cyt') FROM DUAL -- 逐字符比较大小

SELECT SUBSTRING(username,1,2) FROM employee -- 从1位置取2个字符,不写2就是1后面全部

SELECT LTRIM('   ybj') FROM DUAL -- ltrim去掉左边空格。rtrim右边，tirm全部

SELECT CONCAT(LEFT(username,1),UCASE(SUBSTRING(username,2))) FROM employee