sql常见字符串查询语句

#左右截取指定长度查询 =>beijing

SELECT LEFT('beijing2008',7),RIGHT('beijing2008',4)

# 字符串连接查询,与null连接都为null =>aavvvb

SELECT CONCAT('aa','vvvb')

#位置插入查询 =>beijmeng2008you

SELECT INSERT('beijing2008you',5,1,'me')

# 大小写转换 =>beijign2008

SELECT LOWER('BEIJIGN2008'),UPPER('SASaaa')

# 左右填充查询 =>whwhwhwhwhwhwhwh2008

SELECT LPAD('2008',20,'wh'),RPAD('2005',5,'cs')

# 左右去除空格查询 =>asbe2018

SELECT LTRIM('   asbe2018')

# 复制查询=>liuweiliuweiliuwei

SELECT REPEAT('liuwei',3)

# 替换查询 =>najing

SELECT REPLACE('beijing','bei','na')

# 比较ascii码查询  返回结果为-1,0,1

SELECT STRCMP('a','b')

# 去掉头尾空格查询  =>#beijing x

SELECT TRIM('  #beijing x  ')

# 指定位置截取查询 =>201 
SELECT SUBSTRING('beijing2018',8,3)