SELECT * FROM 订单 where 1=1 ${if(len(订单ID)==0,"","and 订单ID LIKE '%"+ trim(订单ID)+ "%'")} ${if(len(货主地址)==0,"","and 货主地址 LIKE '%"+ trim(货主地址)+ "%'") 这个SQL语句末尾少了一个大括号
赞 0 2022-11-22 15:21
您好,感谢提供建议,已修改呢~
赞 0 2023-01-13 10:12
2 评论
SELECT * FROM 订单
where 1=1
${if(len(订单ID)==0,"","and 订单ID LIKE '%"+ trim(订单ID)+ "%'")}
${if(len(货主地址)==0,"","and 货主地址 LIKE '%"+ trim(货主地址)+ "%'")
这个SQL语句末尾少了一个大括号
赞 0 2022-11-22 15:21
您好,感谢提供建议,已修改呢~
赞 0 2023-01-13 10:12