Oracle 可以这样拼LIKE '%'||?||'%'
select * from d_menu where name like '%'||?||'%'
Mysql的话用concat函数
1.
select * from d_menu where name like concat('%',?,'%')
2.问好两边的空格一定不能少
select * from d_menu where name like '%' ? '%'
sqlServer(未测试)
select * from d_menu where name like '%' + ? + '%'