01-07-2009, 06:29 AM
I've avoided having to ask this question by trying to figure out as much as I could on my own, but I'm just not seeing the answer.
Some examples would be super helpful to help my education of working with a database.
Mainly, I need to search records...how do I get searches to return results even if there is a mispelling...or just partial. Is there any way to gauge the exactness of a match?
For Example:
The word in the database is "Gumption"
A user would be able to find that by searching "Gumpshun" "Gumpshen" or "Gumshen" then get the data for "Gumption"
Just some simple examples to point me in the right direction...I've done some research and I figure it has to do with "LIKE patterns" using wildcards and all that jazz.
I've never worked with any of this before, so some stuff to reverse engineer would be sweet.
Thanks,
Jimmy VIg
Some examples would be super helpful to help my education of working with a database.
Mainly, I need to search records...how do I get searches to return results even if there is a mispelling...or just partial. Is there any way to gauge the exactness of a match?
For Example:
The word in the database is "Gumption"
A user would be able to find that by searching "Gumpshun" "Gumpshen" or "Gumshen" then get the data for "Gumption"
Just some simple examples to point me in the right direction...I've done some research and I figure it has to do with "LIKE patterns" using wildcards and all that jazz.
I've never worked with any of this before, so some stuff to reverse engineer would be sweet.
Thanks,
Jimmy VIg