Hi,
I need to perform a search on a mysql table that holds details of job vacancies. the table has fields such as job title and job description.
Now I need to use a fuzzy search technique to allow the user to enter the incorrect spelling of job titles for example. I've looked at using the "like %jobTitle%" in the sql query but i need something a bit more meaty!
I've been looking at using something like the levenshtein function within php (http://www.w3schools.com/php/func_string_levenshtein.asp) but I'm not sure on how to incorporate it into my form.
If anyone could help me out I'd be very grateful!
Thanks
Paul
I need to perform a search on a mysql table that holds details of job vacancies. the table has fields such as job title and job description.
Now I need to use a fuzzy search technique to allow the user to enter the incorrect spelling of job titles for example. I've looked at using the "like %jobTitle%" in the sql query but i need something a bit more meaty!
I've been looking at using something like the levenshtein function within php (http://www.w3schools.com/php/func_string_levenshtein.asp) but I'm not sure on how to incorporate it into my form.
If anyone could help me out I'd be very grateful!
Thanks
Paul