[hookup]

Let's say I have a search page with a single field on it labeled search. If I search for computer, wireless, I get all results that have either computer and/or wireless in them. If I want only the results that have computer and wireless in them what is the best way to fo this. Below is my mysql query

SELECT *
FROM resources
WHERE match (name, keywords ) against ('search*' in boolean mode)
ORDER BY resources.Name

The (search*) is the variable that is passed from the search page. in this case it would be computer+wireless

[nekeno12]

You'll want to set up your search field to intepret some sort of syntax.

A: You wrap double-quotes around a search term to specify that you would like the search to include the entire phrase.

B: You expand your search query to include one word at a time OR the entire phrase, returning your results with a percentage match based on input.

Just use google or any SE for that matter as an example of how your search input should be specified.

[hookup]

thanks nekeno12, your second option was the one that worked for me