有一下sql语句:
select t2.logdate as logdate,
t2.procname as procname,
t2.begin_date as begin_date,
from t_log t2
where t2.procname like '% p_interface_income('CDR_IGO') %'
order by t2.logdate desc现在的问题是:在like模糊查询时,如果字段的内容为“p_interface_income('CDR_IGO')”这种形式时,
无法查询,会报错。有什么解决办法呢?
select t2.logdate as logdate,
t2.procname as procname,
t2.begin_date as begin_date,
from t_log t2
where t2.procname like '% p_interface_income('CDR_IGO') %'
order by t2.logdate desc现在的问题是:在like模糊查询时,如果字段的内容为“p_interface_income('CDR_IGO')”这种形式时,
无法查询,会报错。有什么解决办法呢?
p_interface_income('CDR_IGO')是数据内容,不能这么改变。