title: MySQL LIKE multiple fields condition
body: <p>I just want to start out by saying that I am new to MySql, so I might be doing something really stupid here. I want to make a search by 3 fields, here is my query:</p>
  
  <pre><code>@Query( value = "SELECT from Parent p WHERE p.login LIKE :search OR p.firstName LIKE :search OR p.lastName LIKE :search AND p.school = :school AND p.status = :status")
  </code></pre>
  
  <p>As you can see I want to search by 3 fields: firstName, lastName and login.
  I also added some other conditions like I want it from a particular School and Status.</p>
  
  <p>The search with the 3 fields work, let's say I write "Sarah" in the search and I get back 5 users the problem is that for example if I select in the filter the status = "Confirmed" - looks like the mysql doesn't care about this and still returns all the users with the string "sarah" in it despite their school or status conditions. What am I doing wrong here?</p>
  
  <p>If I use only one Like - ex. only firstName - everything works perfectly... is it possible to use 3 with the conditions?</p>