I need to look-up records in a MySQL table using a name field that has been extracted from an SEO-friendly URL and where any apostophes in the name have been removed.
For example, my source field might be "archers place" for a record which actually stores the name as "Archer\'s Place".
I do seem to be getting the results I want with the following query...
SELECT * FROM mytable
WHERE SOUNDEX(table_Name) = SOUNDEX('archers place')
However, I would appreciate some guidance as to whether this is the corret/best way or whether there are other more efficient/accurate ways of treating this situation.
Thanks in anticipation of your advice.