不同数据库语法不一样的,MySQL:
1 | select * from user where name like concat( '%' , #{ name }, '%' ); |
oracle:
1 | select * from user where name like '%' || #{ name } || '%' ; |
不同数据库语法不一样的,MySQL:
1 | select * from user where name like concat( '%' , #{ name }, '%' ); |
oracle:
1 | select * from user where name like '%' || #{ name } || '%' ; |