杜

<if test="entity.quarterId != null and entity.quarterId != ''"> and FIND_IN_SET(#{entity.quarterId},quarter_id) </if> 判断传入的值，是否在数据库字段中存在，比较类似于like 以上判断传入的quarterId是否在数据库字段quarter_id（此字段多个id以逗号分隔）中存在 ...

原mapper的sql语句如下： <select id="countOutFinishedOrdersByDeliverSign" resultType="int" > select count(1) cnt from order_customer where status = #{status} <if test="sign!=null and sign!='' and sign=='1'"> AND tms_delivery_fl