THE PROBLEM: When searching large text fields, the search retrieves too much or too little.
EXAMPLE OF TOO MUCH: Let's say my user is searching for the word "son". I want him to receive all results that have the word "son", but NOT "garrison", "sonnet", or "Branson".
My first thought is to change "son" to " son " (adding spaces) prior to executing the search. Well, then you create another problem...
EXAMPLE OF TOO LITTLE: Let's say my user is searching for the word "son". Well, with the word changed to " son ", the search will miss any instances that begin or end the text field AND any instances that are next to a punctuation character.
What's a solution?
EXAMPLE OF TOO MUCH: Let's say my user is searching for the word "son". I want him to receive all results that have the word "son", but NOT "garrison", "sonnet", or "Branson".
My first thought is to change "son" to " son " (adding spaces) prior to executing the search. Well, then you create another problem...
EXAMPLE OF TOO LITTLE: Let's say my user is searching for the word "son". Well, with the word changed to " son ", the search will miss any instances that begin or end the text field AND any instances that are next to a punctuation character.
What's a solution?