Search Results to narrow down to complete keyword

When I do a search, I get results for All the words in the keyword field individually instead of having it narrowed down to the 'whole' of the words in the keyword field. For example, when I search for 'Aluminun Core Cone' I get all results that include any of those words. I would like to get in this case only the results that include exactly those words only.

Here's my code:

<?php
$searchWADAcac_prod_subcategory_leveltwo_NEW_WADbSearch1 = new WA_MySQLi_Search("WADAcac_prod_subcategory_leveltwo_NEW","");
if (isset($_GET["Search"]) || isset($_GET["Search_x"])) {
$searchWADAcac_prod_subcategory_leveltwo_NEW_WADbSearch1->clearSearch();
$searchWADAcac_prod_subcategory_leveltwo_NEW_WADbSearch1->setSearch(array("type"=>"Key", "comparison"=>"includes", "join"=>"AND", "and"=>", ", "or"=>" ", "start_encap"=>"\"", "end_encap"=>"\""), array("prod_name", "prod_name2", "part_no"), "s", "".(isset($_GET["prod_name"])?$_GET["prod_name"]:"") ."");
}
?>

I've also attached the file. Thank you.

This is controlled by this code:

"and"=>", ", "or"=>" ", "start_encap"=>"\"", "end_encap"=>"\""

this says that any space is an OR and any comma-space is an AND

It also makes it so any search enclosed in quotes is treated as a whole phrase search.

so searching: this that

will return results for: 'this' OR 'that'

searching: this, that

will return results for: 'this' AND 'that'

and searching: "this that"

would return the exact match: 'this that'

You can change those settings. If you leave the and and or values blank then everything would be an exact match like:
"and"=>"", "or"=>"", "start_encap"=>"\"", "end_encap"=>"\""

Thanks for that awesome explanation. That's great to know. It's pretty powerful! I can work with it now.

below

Let me know if you need help with this today. I'd want to do a screen share and quick phone call to make sure we were doing what you want, but I have some time today if you need it.

I have question along the same lines on same file. I want it to return results if keywords (that include only a space) have the search keyword in either of two tables in the db. So,for example, I search for '1 inch plastic', but '1 inch' is on one table, and 'plastic' in another. It doesn't produce results when trying to do that, unless I use a comma of course, which produces too many results. Below is my code: (they body have the fields included)

I don't think that is going to be easy to pull off.

So let's say you do a search for "1 inch plastic"

How would the code know to look for "1 inch" in one column and "plastic" in the other? What not "1" and "inch plastic"? or "1" and "inch" and "plastic"? What if it finds the entire string "1 inch plastic" in the first table? What about the second? What if they type "plastic 1 inch"?

You are going to have to somehow identify what to look for in each column and what the rules are when searching. You might want to just add two fields instead of one.

ok. thanks. Just need to let my boss know. He wants everything easy so I don't think he'll want the two search fields as he keeps pushing for less complicated and less steps to use, and wants the program to figure out what he's thinking. :)