截取出工资的上下限
方法一:用left()和right()函数,嵌套使用获取上限
语法:LEFT(ARG,LENGTH)、RIGHT(ARG,LENGTH)
LEFT、RIGHT函数返回ARG最左边、右边的LENGTH个字符串,ARG可以是CHAR或BINARY STRING。
SELECT left(salary,locate('k',salary)-1),
locate('-',salary),
length(salary),
right(salary,length(salary)-locate('-',salary)),
left(right(salary,length(salary)-locate('-',salary)),length(salary)-locate('-',salary)-1),
salary
from data.dataanalyst
运行结果:
方法二:substr()函数,从中间截取获取上限
语法:SUBSTR(str,pos,len);
SELECT left(salary,locate('k',salary)-1),
locate('-',salary),
length(salary),
substr(salary,locate('-',salary)+1,length(salary)-locate('-',salary)-1),
salary
from data.dataanalyst
运行结果: