oracle:select * from stu where name like '%'||#name #||'%'
:select * from stu where name like '%'$name$'%'
mysql: select * from stu where name like concat('%',#name #,'%')
sqlserver: select * from stu where name like '%'+#name #+'%
oracle:select * from stu where name like '%'||#name #||'%'
:select * from stu where name like '%'$name$'%'
mysql: select * from stu where name like concat('%',#name #,'%')
sqlserver: select * from stu where name like '%'+#name #+'%