Is there a way that I can tell MySQL to select all records of which have a value in a column (BLOB) similar to 90% or some arbritary value? Example:
SELECT * from table where name LIKE "%harold%"
Then if that returns no results, is there a query which I can build again in SQL which will match similar text to some percentage? I am thinking of a function similar to:
If the above is not doable, can you say what an alternative solution might be to finding "similar" or closely matched records?
Thanks in advance.