【formula】sql+like拼接

tech2023-01-19  118

oracle :

  select * from table_name where second_name like '%'||:secondName||'%'

 

mysql:

 select * from table_name where second_name like concat('%', :second_name ,'%')

最新回复(0)