Full-Text Search

MySQL Function: Full-Text Search
  • LIKE
  • MATCH()
  • NOT LIKE
  • NOT REGEXP
  • REGEXP
  • REGEXP_INSTR()
  • REGEXP_LIKE()
  • REGEXP_REPLACE()
  • REGEXP_SUBSTR()

Reference