Yii select distinct criteria Query
Yii select distinct criteria Query Syntax And Example : Yii Query builder is used to select records from table.
Yii select distinct criteria Query Syntax
$criteria = new CDbCriteria(); $criteria->distinct=true; $criteria->condition = "id=".$id ; $criteria->select = 'id,name,email'; $modal=Users::model()->find($criteria); |
Which will return the distinct row from table.
//SELECT DISTINCT id,name, email FROM users WHERE id = “5”
where $id = 5;
Advertisements
