Skip to main content
J
johngordon12
Inspiring
August 23, 2006
Question

searching for multiple phrases

  • August 23, 2006
  • 1 reply
  • 261 views
At the moment I use Tom Muck's excellent search extension that can search on any word, all words or exact phrase.

However, I have a requirement to search on multiple phrases, eg "aviation engineer" & "technical knowledge".

Can anyone point me in the direction of how to achieve this?

Cheers,
Iain
This topic has been closed for replies.

1 reply

J
johngordon12Author
Inspiring
August 25, 2006
The closest I've gotten to doing this is to use the SQL :

SELECT *
FROM table_name
WHERE field_name LIKE '%search_field%'

So if the search was on 'Aviation Experience%Technical Knowledge' it would work - but only if the phrases appeared in that order, and fail otherwise.

So what I'm looking for is the ability to find the multiple phrases regardless of the order in which they appear.

Hope that makes sense, and someone can help.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices