I currently have a coldfusion page that contains a search field that allows a user to enter a search term that could be any string. I received help with getting the query to find search terms no matter what order they were in the database field. Basically it will search for any of the search string words. Now I would like to have the database query search for all of the words in any order in the database field. I tried to just change the query that I am using to having AND instead of OR between the Where items but it gives and error.
Currently when a user enters a search term such as 7ft metal it will return anything that matches either of those keywords . I wanted to know if there is a good way to make it so that the search terms can be in any order in the database field so that search will return items that are labeled both metal and 7ft as part of their description.
Any help would be appreciated.