一.字符串函数
select concat(name,"age is",age) from users;
insert(str,x,y,insert)//将字符串x位置开始y个位置替换成insert
select lower(str) upper(str)//转化大小写
select * from user where upper(name)='AAA';
left (str ,x) right(str,x)//分别返回左边和右边的x个字符
select left ("abcdee",3),right("abcdedd",3),left("abcdedd",null);
lpad(str,n,pad),rpad(str,n,pad)//用字符串pad对str最左边或最右边补到n位
ltrim()
substring(str,x,y)//返回字符串中得第x位置起,取y个字符