Sphinx search multiple keywords on concat fields
I need to search multiple keywords on all fields as if they were one string.

Example:
sphinx.conf
sql_query=SELECT prod_id,prod_name,prod_groupname,prod_brandname,prod_countryname,prod_store
from products as prod

---

Search terms: [ telephone canada ]

Sphinx seems to search all words on each field. This is not what I need.

I need the search to seek ALL WORDS on ALL FIELDS (as they were a concat(prod_name,' ',prod_proupname,' ',prod_brandname,' ',prod_countryname,' ',prod_store) )

And if not found: search for any word 

Thanks for any clue :-)





Sphinx search multiple keywords on concat fields
===

I need to search multiple keywords on all fields as if they were one string.

Example:
sphinx.conf
sql_query=SELECT prod_id,prod_name,prod_groupname,prod_brandname,prod_countryname,prod_store
from products as prod

---

Search terms: [ telephone canada ]

Sphinx seems to search all words on each field. This is not what I need.

I need the search to seek ALL WORDS on ALL FIELDS (as they were a concat(prod_name,' ',prod_proupname,' ',prod_brandname,' ',prod_countryname,' ',prod_store) )

And if not found: search for any word 

Thanks for any clue :-)




