Search queries: AND

Hi Greg, 

Yes, that's what it will do by default so that should work no problem.

Let me know if you have any other questions.

Hi Dave,

Thanks for getting back to me. That's great!

And if I want to use an OR operator then I would do this:

/search.php?product_keyword[]=Sony&product_keyword[]=HD

Is that right?

Thanks again.

Greg

Hi Greg, 

Yes, that's right.  And if you want to see the actual MySQL that is being generated for debugging purposes you can add the option: 

'debugSql' => true,

Hope that helps!

Hi Dave,

That's useful to know, thanks.

Also, can you clarify what the difference is (if any) between:

/search.php?product_keyword[]=Sony&product_keyword[]=HD

...and

/search.php?product[]=Sony&product[]=HD

Thank you,

Greg

Taking a stab at it, I think product_keyword=HD would find HDMI whereas product=HD would not find it?

Would product=HD and product_match=HD be the same query?

Hi Guys, 

Yea, that's right.  *_keyword matches if the keyword is anywhere in the value.  Otherwise, it needs to be an exact match.

Reference: https://www.interactivetools.com/docs/cmsbuilder/viewer_search.html

Thanks guys for your help! Really good to now understand this.

Regards,

Greg