Splitting SQL search string and making all combinations of the words
I have come across a challenge (for me at least) that I need to split an SQL search string into words and make all combinations of those.
For example, the DB field contains the following:
HILTON WASHINGTON, 1919 CONN AVE., NW, DC., 20009
The user might search for:
hilton conn ave
hilton NW dc
I wanna to put all possible combinations into SQL query using 'OR' so that the user gets the right result.
Any idea how to implement this or any other good idea for the search criteria will be appreciated..
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)