sql like模糊查询的条件拼接
被坑了两次,记录加深记忆
oracle :
select * from table_name where 1=1
<#if secondName?? && secondName?has_content>
and second_name like '%'||:secondName||'%'
</#if>
mysql:
select * from table_name where 1=1
<#if secondName?? && secondName?has_content>
and second_name like concat('%', :second_name ,'%')
</#if>