how do I delete rows in Yii?

Question

Using Yii, I want to delete all the rows that are not from today. Is my solution ok ? ``` $query = "delete from `user_login_hash` where `day`!='".(date('Y-m-d',time()))."'"; Yii::app()->db->createCommand($query); ```

Accepted Answer

A prettier solution is

```
YourUserModel::model()->deleteAll("day !='" . date('Y-m-d') . "'");
```

how do I delete rows in Yii?

Solution

Problem