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