多个条件or模糊查询

最新推荐文章于 2024-06-23 11:00:16 发布

月丨曦

最新推荐文章于 2024-06-23 11:00:16 发布

阅读量2.6k

点赞数

本文链接：https://blog.csdn.net/weixin_43830876/article/details/99623984

版权

在这里插入图片描述

 SELECT
        ab.APPLY AS apply,
        ab.BUS AS bus,
       cb.NAME AS name,
        p.CODE AS code,
        p.REMARK AS remark
        FROM
      apply ab
        LEFT JOIN buyer cb ON ab.id = cb.ab_id
        LEFT JOIN project p ON ab.code = p.code
  
                AND ab.code  = #{code }
       
                AND
                ( ab.nO =  #{string}
                OR p.REMARK  like concat('%',#{string},'%')
                OR cb.INSURED_NAME  like concat('%',#{string},'%'))
       
            AND
            ab.STATUS = '1'
            ORDER BY
            ab.UPDATE_TIME DESC