Syntax\n------\n\nMATCH (col1,col2,...) AGAINST (expr [search_modifier])\n\nDescription\n-----------\n\nA special construct used to perform a fulltext search on a fulltext index.\n\nSee Fulltext Index Overview for a full description, and Full-text Indexes for more articles on the topic.\n\nExamples\n--------\n\nCREATE TABLE ft_myisam(copy TEXT,FULLTEXT(copy)) ENGINE=MyISAM;\n\nINSERT INTO ft_myisam(copy) VALUES ('Once upon a time'), ('There was a wicked witch'), \n ('Who ate everybody up');\n\nSELECT * FROM ft_myisam WHERE MATCH(copy) AGAINST('wicked');\n+--------------------------+\n| copy                     |\n+--------------------------+\n| There was a wicked witch |\n+--------------------------+\n\nURL: https://mariadb.com/docs/server/reference/sql-functions/string-functions/match-against