title: Not equal condition with findAll()
body: <p>I am trying to pull record from a table using the following code </p>
  
  <pre><code>$userId = Yii::$app-&gt;user-&gt;id;
  $lists = PromoLists::findAll(['user_id' =&gt; $userId, 'list_type' =&gt; 'custom']);
  </code></pre>
  
  <p>which outputs a query like below</p>
  
  <pre><code>select * from promo_lists where user_id ='$userId' and list_type='custom'
  </code></pre>
  
  <p>But i am unable to find any thing in the documentation that would help me achieve it with the following condition.</p>
  
  <pre><code>select * from promo_lists where user_id ='$userId' and list_type='custom' and status!='deleted'
  </code></pre>
  
  <p>as the status is an <code>ENUM</code> field and there are 4 different status </p>
  
  <pre><code>'active','pending','rejected','deleted'
  </code></pre>
  
  <p>currently i used the following approach</p>
  
  <pre><code>PromoLists::findAll(['user_id' =&gt; $userId, 'list_type' =&gt; 'custom', 'status'=&gt;['active','pending','rejected']]);
  </code></pre>
  
  <p>which outputsthe following query</p>
  
  <pre><code>select * from promo_lists where user_id ='$userId' and list_type='custom' and status in ('active','pending','rejected')
  </code></pre>
  
  <p>which somehow achieves the same thing but this query would need to be edited every time when there is a new status type added to the table column <code>status</code>.</p>
  
  <p>i know  i can do this by using <code>PromoLists::find()-&gt;where()-&gt;andWhere()-&gt;all()</code> </p>
  
  <p>but how to check with <code>!=</code> / <code>&lt;&gt;</code> operator using <code>findAll()</code>.</p>