Results 1 to 3 of 3
Thread: Match against & plurals
Apr 9, 2010, 12:36 #1
Match against & plurals
I'm doing a simple match against query against 3 fields, but I've noticed a problem when searching for plural words.
For example, if I search for "penguin" I get 3 results about penguins, but if I search for "penguins" I get one result--the one result from the 3 that has the plural form of the word. It really seems to be behaving as if it were a LIKE statement.
What I want to do, is have the search work for multiple forms of the word. I realize I could just add an "s" or take off an "s" and do an OR, but I don't want it to work just for plurals, but for similar forms of the same word. Is there any way to make it less sensitive?
Apr 9, 2010, 21:58 #2
- Join Date
- Oct 2003
- St. Catharines, ON Canada
- 0 Post(s)
- 0 Thread(s)
Apr 9, 2010, 22:00 #3
Ahh, I think you're right--I wasn't aware that existed.