[size=12px]有一下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')”这种形式时,
因为“p_interface_income('CDR_IGO')”是数据表中的内容,
无法实现查询,会报错。有什么解决办法呢?[/size]
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')”是数据表中的内容,
无法实现查询,会报错。有什么解决办法呢?[/size]
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
---------- -------------------------------------------------------------------------------- ------------------
1 p_interface_income('CDR_IGO') AAANgoAAEAAAAGkAAASQL>
SELECT 'p_interface_income(''CDR_IGO'')' FROM dual;