45. 截取“测试数据”后面的内容

Posted on 2019-12-20 11:31  zkx4213  阅读(118)  评论(0编辑  收藏  举报

select substr(description, instr(description,'测试数据',1,1)+6) from test;
select substr(description,instr(description,'测试数据',1,1)+6) from test where description like '%有履行能力%' ;

Copyright © 2024 zkx4213
Powered by .NET 8.0 on Kubernetes