MATCH(column) AGAINST('keyword') syntax for columns with no FULLTEXT index.
Let's run the following query on column first_name that has not FULLTEXT index:SELECT *
FROM students
WHERE MATCH(last_name) AGAINST('გიორგი')Then we will get the error:#1191 - Can't find FULLTEXT index matching the column list
Note: MATCH(column) AGAINST('keyword') syntax can only be used on columns with FULLTEXT index