How do I set up a search for of database searching for 2 words in different orders

[Glenn]

How do I search a database for example, if someone puts in "loose foot", it would return any instance of the word foot with the word loose. If they search loose foot, and foot loose is in the database, it would show up in the search.

 

[n1c0_ds]

How do I search a database for example, if someone puts in "loose foot", it would return any instance of the word foot with the word loose. If they search loose foot, and foot loose is in the database, it would show up in the search.

Don't accept my answer before confirming with other peers, but your SQL query should be something like ... AND column LIKE %foot% AND column LIKE %lose%

Any result having those two words would be returned. That being said, there are better, more complex ways.