首页 » MySQL正则表达式

select supplimental_id, url, path 
  from c4_contest_enroll_supplemental ces 
  left join c4_docscnv d on ces.supplimental_id=d.doc_id 
  where path is null and url REGEXP '\.ppt$|\.pptx$|\.docx$|\.doc$';