sql中instr的用法

    task_content包含inspect_no字段，并进行关联查询

SELECT r.* FROM  (SELECT DISTINCT(i.inspect_id) FROM  task_info t,   inspect_report i  WHERE      instr(          t.task_content,          i.inspect_no      ) > 0  AND i.mar_no = #{marNo,jdbcType=VARCHAR}  AND t.type = 1  AND t.task_node = 'HEADQUATER_CHECK'  AND t.task_status = 'PROCESSED'  AND i. status = 'CHECKED'  ) tt JOIN inspect_report r ON tt.inspect_id = r.inspect_id  ORDER BY r.create_time desc