I have a table containing song titles. I want a user who may not be a good typist to be able to search the table effectively.
Suppose I have "American Pie" in my table. How can I construct a SELECT statement that would find this record if the user entered "American Pie" or "American Pi" or "American Pye" or just "Pie"? I don't see how REGEXP or LIKE or SOUNDEX would cover all these possibilities.
Sites like Amazon.com handle this very effectively. Surely there must be a way. Anybody got some experience with this?
Thanks,
- jjt
Suppose I have "American Pie" in my table. How can I construct a SELECT statement that would find this record if the user entered "American Pie" or "American Pi" or "American Pye" or just "Pie"? I don't see how REGEXP or LIKE or SOUNDEX would cover all these possibilities.
Sites like Amazon.com handle this very effectively. Surely there must be a way. Anybody got some experience with this?
Thanks,
- jjt