findBySql() public static method
Creates an yii\sphinx\ActiveQuery instance with a given SQL statement.
Note that because the SQL statement is already specified, calling additional query modification methods (such as where()
, order()
) on the created yii\sphinx\ActiveQuery instance will have no effect. However, calling with()
, asArray()
or indexBy()
is still fine.
Below is an example:
$customers = Article::findBySql("SELECT * FROM `idx_article` WHERE MATCH('development')")->all();
public static yii\sphinx\ActiveQuery findBySql ( $sql, $params = [] ) | ||
---|---|---|
$sql | string |
The SQL statement to be executed |
$params | array |
Parameters to be bound to the SQL statement during execution. |
return | yii\sphinx\ActiveQuery |
The newly created yii\sphinx\ActiveQuery instance |
Please login to continue.