sql like模糊查询的条件拼接

  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>

sql like模糊查询的条件拼接

标签：dna   clear   拼接   rac   where   gpo   like   pos   post