How to check input for possible close match with A DB

Question

Ok i will write as clear as possible

it is an e-commerce website and there are many products

so i have a search form that submits input to php script via jquery post

method (ajax) now what i want to do is check if input is equal (from form)

or close to one of the words in my database, but I can’t write a regular expression for every single word, so

there is a solution

for example, if a client wants to see our offers for pentuim 4, and he wrote a penium, he must say that "you mean pentuim"

I hope that I can get an answer now

-1

Qchmqs Jul 31 '11 at 20:11

1 answer

andyb · Accepted Answer · 2011-07-31T20:40:07+0000

You can just send user input to the LIKE request and get the database to perform the search - they are pretty good at that :-)

If there are no results for an exact match, you can first pass search queries using spell checking or use a fuzzy search.