连结的查询语句,条件参数怎么加进去
select 字段1 as name,字段2 AS age from tab_1
union all
select 字段3 as name,字段4 AS age from tab_2
union all
select 字段5 as name,字段5 AS age from tab_3 | 我想加入这个查询条件,该放到哪里?
${if(len(字段1) > 0 ,"and 字段1 like '%"+字段1+"%'",""}
|
FineReport wanglibo2680
发布于 2017-7-21 16:28
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知