Need to 'fuzzy' search via API or SQL using 'FULL-TEXT' index

Each time I add a new MySQL InnoDB index of type ‘Full Text’ and then re-save the custom DocType, the index is removed.

For example, I have build a custom DocType named Member…

SELECT name,member_name, MATCH (member_name) AGAINST (‘Palmer Logitics’ IN NATURAL LANGUAGE MODE) AS score FROM tabMember order by score desc;

This should fix your problem.

1 Like

I am confused… is the fix in an updated version of Frappe/ERPNext?