mysql oracle sql like模糊查询的条件拼接

被坑了两次,记录加深记忆

oracle :

select * from table_name where 1=1

<#if secondName?has_content>

and second_name like '%'||:secondName||'%'

</#if>

mysql:

　select * from table_name where 1=1

<#if secondName?has_content>

and second_name like concat('%', :second_name ,'%')

</#if>