0
|
snrtuemcLv8专家互助发布于2024-7-16 14:24(编辑于 2024-7-16 14:51)
|
select * from demo where 1=1 and BG='${replace(city,"','","")}' ============== 
|
-
Kenny(提问者)
- 不行哦,是不是写错了引号呢
-
snrtuemc 回复 Kenny(提问者)
- 换个写法,看修改答案
-
Kenny(提问者) 回复 snrtuemc
- 但嵌套的话就不行了,比如:${if(len(city) == 0,""," and BG='${replace(city,"','","")}')},也就是${}中不能嵌套${},否则只会执行内部的那一个${}
-
snrtuemc 回复 Kenny(提问者)
- 嵌套换个写法${if(len(city) == 0,""," and BG='"+replace(city,"','","")+"'")}
|
|