title: Multiple like condition in mysql
body: <p>When i use multiple like condition with AND keyword, it will return false value actually, it had value in table and my query as below:</p>
  
  <pre><code>  SELECT * FROM tbl_student 
    WHERE name LIKE '%jame%' 
    AND ( id LIKE '%001%' 
          AND id2 LIKE '%002%'
         )
  </code></pre>
  
  <p>This query return empty row</p>
  
  <pre><code>SELECT * FROM tbl_student 
  WHERE name LIKE '%jame%' 
  OR ( id LIKE '%001%' 
       AND id2 LIKE '%002%'
     )
  </code></pre>
  
  <p>This query return data</p>
  
  <pre><code>tbl_student
  Name         ID      ID2
  jame          233     3234 
  jame333       1001    0222
  jame333 Da    1001    1002
  </code></pre>
  
  <p>Why it is returned empty data when use AND keyword ?</p>