I have a search tool in my website that returns all items (database = sql server) that contain the search string.
Presently, if I type 'red shirts' into search, it returns all records that contain this string in the description field of the items
Now, i need to modify it.
If an item description contains "shirt - red", then also the above search string (red shirts) should return such items. In other words, my search result should return all items that contain one or more words that were entered in the search irrespective of their sequence (red shirt or shirt - red)
How should I modify my database query?