mysql - Innodb: Can't find FULLTEXT index matching the column list when queried more than 1 columns -


i'm trying run simple query on mysql innodb table:

select *  items  match (item_title,item_description) against ('dog') 

both column item_title , item_description have fulltext index.

i keep getting error:

can't find fulltext index matching column list

my issue: when query just item_title or just item_description works fine. when both @ once in 1 query, shown above, error.

any idea wrong?

you need third index:

fulltext(item_title, item_description) 

Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -