Solved 1191-Can not find FULLTEXT index matching the column list.

ERROR LIST

Unrecognized keyword. (near "AGAINST" at position 47)
Unexpected token. (near "(" at position 54)
Unexpected token. (near "'how to'" at position 55)
Unrecognized keyword. (near "IN" at position 64)
Unrecognized keyword. (near "NATURAL" at position 67)
Unrecognized keyword. (near "LANGUAGE" at position 75)
Unrecognized keyword. (near "MODE" at position 84)
Unexpected token. (near ")" at position 88)

SQL query: Documentation

SELECT * FROM post WHERE FULLTEXT(post_header) AGAINST('how to' IN NATURAL LANGUAGE MODE)

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FULLTEXT(post_header) AGAINST('how to' IN NATURAL LANGUAGE MODE)' at line 1

Here is a simple solution.

Run this SQL query in your database

ALTER TABLE post ADD FULLTEXT index_name(`post_header`)

Where  post is a table name and post_header is field

Now Run your query ...

SELECT * FROM `post` WHERE MATCH (post_header) AGAINST ('how to send mail after' IN NATURAL LANGUAGE MODE)