Could also be missing the min_infix_len setting on the table. That was a problem I had with a recent project. I created the table without that setting and only exact matches were allowed. With that setting, partial matches were allowed via asterisk-based syntax. For example:
`SELECT name FROM index_name
WHERE MATCH('@name *Advent*') LIMIT 50`
Very easy mistake to make. I had created many indexes before but just forgot this setting was needed. Honestly, it should be on by default IMO… it just isn’t enabled by default for whatever reason.