PG的in不生效，使用any(regexp_split_to_array(‘切割内容‘,‘,‘)代替

例子：

@Select("<script>" +
            "select nvl(gr.xingming,'') xingming,gr.zjhm zjhm,yh.id userid,gr.grbh grbh from pt_js js " +
            "inner join pt_yh_js yhjs on yhjs.jsid=js.id " +
            "inner join pt_yh yh on yhjs.yhid=yh.id " +
            "inner join pt_gr gr on gr.grbh=yh.grbh " +
            "where js.jgbh=#{organizationNumber} " +
            "and gr.xingming like '%'||#{xingming}||'%' " +
            "and yhjs.bmbh =any(regexp_split_to_array(#{bmbh},',')) group by gr.grbh,yh.id,gr.zjhm,gr.xingming" +
            "${note}" +
            "</script>")
           

解釋：

例子中#{bmbh}的值，eg：“值1,值2,值n”