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

Glenn · 11-19-2011, 08:27 PM

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 · 11-25-2011, 04:56 AM

Quote:

Originally Posted by 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.

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.

11-19-2011, 08:27 PM	#1
Glenn Silver Member Join Date: Aug 2011 Location: Tennessee Posts: 112	How do I set up a search for of database searching for 2 words in different orders 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode