How to do a search on a specific field using php sphinxapi?

Question

PHP

When running from the console, the where match('@category_id 42') query returns matches on the category_id field.
Through my code:

$cl = new SphinxClient();
$cl->SetServer(SLAVE_HOST, 9312);
$cl->_limit = 300000;
$cl->SetLimits(0, 10000, 10000);
$cl->setMatchMode(SPH_MATCH_EXTENDED2);
$keyword = '@category_id 42';
$keyword = $cl->EscapeString($keyword);
$result = $cl->Query($keyword, 'customers');

Finds no matches. Please tell me what could be wrong.

Answer 1

In general, the answer is found the problem is in this line
. It escaped the @ sign and the request was not read correctly.

Answer 2

If category_id is an attribute, then the setFilter function must be used here. And probably it is not necessary to thrust such fields into a full-text index.