title: yii2 ActiveQuery 'OR LIKE' filter
body: <p>i have a task - add to search model searching by full name.
  Full name is first name + last name. So i need to build query like</p>
  
  <pre><code>WHERE first_name LIKE '%var%' OR last_name LIKE '%var%'
  </code></pre>
  
  <p>The only way i could do it :</p>
  
  <pre><code>$query-&gt;andFilterWhere([
  'OR',
  'profiles.first_name LIKE "%' . $this-&gt;userFullName . '%" ',
  'profiles.last_name LIKE "%' . $this-&gt;userFullName . '%"'
  ]);
  </code></pre>
  
  <p>But i dont like it because % its unsafe.
  I dont know how... 
  I think there is the way to build such query with yii2 active builder, and i would like to get in result smth like</p>
  
  <pre><code>$query-&gt;andFilterWhere(['LIKE', 'profiles.first_name', $this-&gt;userFullName]);
  $query-&gt;andFilterWhere(['OR LIKE', 'profiles.last_name', $this-&gt;userFullName]);
  </code></pre>
  
  <p>The problem is in the query Like, i could use array as the values that attribute will be comapred but i cant use array as list of attributes to be compared with.</p>
  
  <p>or</p>
  
  <pre><code>$subQuery1 = Profile::find()-&gt;Where(['LIKE', 'profiles.first_name', $this-&gt;userFullName]);
  $subQuery2 = Profile::find()-&gt;Where(['LIKE', 'profiles.last_name', $this-&gt;userFullName]);
  //i think its overloaded(3 queries insteadof 1 but still) and the final query
  $query-&gt;andFilterWhere([
  'OR',
  $subQuery1,
  $subQuery2
  ]);
  </code></pre>
  
  <p>Any ideas how to build query whithout "%"?</p>