以字符串‘t2’为关键字,message为查询字段,提取sql语句如下:
select* ,case when message like '%t2%' then (length(message)-length('t2')) end as rn from total where message like '%t2%' order by rn;
这个语句的case when 完全可以去掉,修改后的sql语句如下:
select* ,(length(message)-length('t2')) as rn from total where message like '%t2%' order by rn;
select* ,case when message like '%t2%' then (length(message)-length('t2')) end as rn from total where message like '%t2%' order by rn;
这个语句的case when 完全可以去掉,修改后的sql语句如下:
select* ,(length(message)-length('t2')) as rn from total where message like '%t2%' order by rn;