created a fulltext index on field name in table users. am i not able to search for substrings in a mysql fulltext index? for example, how would i translate this query:
select * from users where name like '%ana%';
which would then return all users with the letters 'ana' in their name.
this is done in MS SQL Server using the fulltext predicate 'contains'. is there anything similar in MySQL? or does MySQL fulltext index only return whole words?