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