当前位置：网站首页>mysql FUNCTION xxx.charindex does not exist

mysql FUNCTION xxx.charindex does not exist

2022-04-22 13:07:00 【子言慕雨】

把charindex替换为instr

<select id="selectAllCount" resultType="Long" parameterType="list">
        select COUNT(1)
        from notice
        <where>
            <if test="list != null and list.size()>0 ">
                <foreach collection="list" item="id" open="(" close=")" separator="or">
                    instr(','+#{id}+',',','+notice_org_ids+',')>0
                </foreach>
            </if>
        </where>
    </select>