mybits使用@select标签拼接sql

@Select({"<script>",

“select m.id,m.name_,m.level_,m.pid,m.type,m.order_,p.id as

pictureId,p.picture,i.route " +

“from t_sys_menu m " +

“LEFT JOIN t_sys_menu_info i on m.id = i.menu_id " +

“left JOIN t_sys_picture p on p.id = i.picture_id " +

“where m.stop_flag = 0 and m.pid = #{pid} " +

“<when test=’ field != null and field != \”\” ’ > and m.name_ like

#{field} </when> " +

“order by order_ asc”

,"</script>”})

List<MenuVo> fuzzyQueryMenu(@Param(“pid”) Long pid,@Param(“field”) String

field);