How to search in sphinx using and and or?

Question

Sphinx

Good day.
There is a code with something like this logic:

$condition = '';
$order = 'id desc';
$limit = '0,30';

if($params['id'] == 0){
  $condition = '
    (user_id = :user_id and !user_deleted)
    or (from_id = :user_id and !from_deleted)
  ';
} else {
  $condition = '
    (user_id = :user_id and from_id = :from_id and !user_deleted)
    or (user_id = :from_id and from_id = :user_id and !from_deleted)
  ';
}

if(isset($params['lastId']) && $params['lastId']){
  $condition = '('.$condition.') and id > :lastId';
  if(!isset($params['firstId']) || !$params['firstId']){
    $order = 'id asc';
  }
}
if(isset($params['firstId']) && $params['firstId']){
  $condition = '('.$condition.') and id < :firstId';
}
if(isset($params['text']) && $params['text']){
  $condition = '('.$condition.') and text like :text';
  /* :text = '%'.$params['text'].'%' */
  $limit = -1;
}

Search through mysql works, but how to rewrite it through sphinx? And it's even better if you show how it's done in yii1 using the DGSphinxSearch extension.
Thanks in advance.

Answer 1

What kind of tin do you have, use sphinxql

Answer 2

What does it mean to rewrite through sphinx and why is it needed?