@Select("SELECT COUNT(*) FROM t_test WHERE name LIKE CONCAT('%',#{name},'%')")
Long getByName(@Param("name") String name);
IN 查詢
@Select({"<script>",
"SELECT name FROM t_test WHERE id IN",
"<foreach collection='ids' item='id' open='(' separator=',' close=')'>#{id}</foreach>",
"</script>"})
List<String> getByIds(@Param("ids") List<Long> ids);
