searching for multiple phrases

[johngordon12]

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

[johngordon12]

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.