title: Doctrine search a string in multiple columns
body: <p>I hope you can help :)</p>
  
  <p>This is how the table looks:</p>
  
  <pre><code>+------------+----------------+------------------+---------+
  | firstName  | lastName       | email            | etc...  |
  +------------+----------------+------------------+---------+
  | John       | Doe            | john@doe.com     | etc...  |
  +------------+----------------+------------------+---------+
  | John       | Michaels       | john@michaels.es | etc...  |
  +------------+----------------+------------------+---------+
  </code></pre>
  
  <p>This is how the code looks:</p>
  
  <pre><code>if($_GET['search-customers'] != '') {
      $busqueda = $_GET['search-customers'];
      $query-&gt;andWhere("(c.firstName LIKE '%$busqueda%' OR c.lastName LIKE '%$busqueda%' OR c.email LIKE '%$busqueda%')"); 
  }
  </code></pre>
  
  <p>With that QUERY:</p>
  
  <ul>
  <li>If I input: <em>John</em> in the search box, <strong>it gives me the 2 results.
  OK</strong></li>
  <li>If I input: <em>John D</em> in the search box, <strong>it doesn't give me any result. FAIL</strong></li>
  </ul>
  
  <p>All right, I understand, When I type "<em>John D</em>", it try to find first in firstName (doesn't match) and also it doesn't match <em>lastName</em> or <em>email</em>.</p>
  
  <p>How can I combine them?</p>
  
  <p>The idea its to <strong>find the complete string in all possibilities</strong>.</p>
  
  <p>Thanks!</p>