|
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,"','","")+"'")}
|
|
1min目标场景问卷
立即参与
