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

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

原文地址:https://www.cnblogs.com/zkx4213/p/12072199.html