logo
Blog single photo

1191 - Can not find FULLTEXT index matching the column list


                        

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

SOLVED ------

ALTER TABLE post ADD FULLTEXT index_name(`post_header`)


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


Top