SELECT DATA WHERE FIELD不是NULL

问题描述：

I'm trying to select the all the data from a table "users" where the "reset_code_date" is not null. How can I do this with propel?

Now I have this:

$canceledusers = UserQuery::create()->filterByResetCodeDate()->find();

As you can see, now I select all the fields where the reset_code_date IS NULL. But how can I select all the fields where it is not null?

答

Try this:

$canceledusers = UserQuery::create()->where('reset_code_date is not null')->find();

答

$canceledusers = UserQuery::create()
    ->filterByResetCodeDate(null, \Criteria::ISNOTNULL)
    ->find();