MATCH & AGAINST syntax can not be used for columns with no FULLTEXT index
It's not possible to use
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
by Valeri Tandilashvili
4 years ago
MySQL
FULLTEXT index
1
Pro tip: use ```triple backticks around text``` to write in code fences