ibatis中使用like模糊查询
无效的方法:
select * from table1 where name like '%#name#%'
select * from table1 where name like '%$name$%'
mysql:
select * from table1 where name like concat('%', #name#, '%')
select * from table1 where name like '%' || #name# || '%'
select * from table1 where name like '%' + #name# + '%'