SELECT
*
FROM table
where 1=1
${IF(len(NAME)==0,"","and SKU_NAME like '%"+NAME+"%'" )}
这个NAME的值是从文本控件取的,有特殊字符\ ,请问怎么解决?
replace(SKU_NAME,'\','') 参数里面写 ${IF(len(NAME)==0,"","and replace(SKU_NAME,'\','')like '%"+NAME+"%'" )}
先把特殊符号用replace替换掉不就好了
查询的时候也必须带上这个\么?
使用replace,把\改为\\