mybatis中like查询的问题求解

Question

select name from area where id like "%"#{id}"%"
这样写为什么不对啊

Answer 1

select name from area where id like CONCAT(CONCAT('%', #{id}), '%');

试一下