2
、在代码上对传入的关键字进行
CONVERT
编码转换
如上面的例子的
sql
:
SELECT id,mail_2011_06_22.service_code,cur_time,concat(‘mail_2011_06_22′) as tabName,’mail’ as service FROM mail_2011_06_22 WHERE 1=1
AND
( state_type=3 OR ( state_type=0 AND flag !=0) ) AND (service_type=’0003′ OR service_type=’0004′ OR service_type=’0005′ OR (service_type=’0006′ AND direction=’0′ ) ) AND
( state_type=3 OR ( state_type=0 AND flag !=0) )
AND ( CONCAT_WS(”,mail_2011_06_22.host,mail_2011_06_22.account,mail_2011_06_22.send,mail_2011_06_22.recv,mail_2011_06_22.cc,mail_2011_06_22.bcc ,mail_2011_06_22.title, mail_2011_06_22.text,mail_2011_06_22.raw_