我的sql:
SELECT member_id from access_layer where node_id in("1,2,3","1,2,4","1,3,4","1,3,5") and node_id like "%1,3%";
<select id="findCPByNode_id" parameterType="map"
resultType="string">
SELECT member_id from access_layer where node_id in
<foreach collection="list" item="node_id" index="index"
open="(" separator="," close=")">
#{node_id}
</foreach>
and node_id like CONCAT(CONCAT('%',#{node_id}), '%')
</select>