How to add condition in Where yii2?

Question

MySQL

There is a request

$news = self::find()->where(['status' => self::STATUS_ENABLE])->andWhere(['datePublished' => '2016-04-04'])->all();

How do I add a condition like datePublished < '2016-04-04' in andWhere ?

Answer 1

Maybe so?

->andWhere('datePublished< :datePublished',[':datePublished' => '2016-04-04']);

Answer 2

Try the following example:

$news = self::find()
          ->where(['status' => self::STATUS_ENABLE])
          ->andWhere([ '<', 'datePublished', '2016-04-04'])->all();

Answer 3

Maybe so?

$news = self::find()
          ->where(['status' => self::STATUS_ENABLE, 'datePublished' => '<2016-04-04'])->all();

or so -

$news = self::find()
          ->where(['status' => self::STATUS_ENABLE'])->andWhere('datePublished < :datePublished',[':datePublished' => '2016-04-04'])->all();

Answer 4

$news = self::find()
          ->where(['status' => self::STATUS_ENABLE])
          ->andFilterWhere([ '<', 'datePublished', '2016-04-04'])->all();