title: Mysql - why AND in where is not considered?
body: <p>In the below query even position and category_id conditions are met there is no record 
  retrieved.</p>
  
  <pre><code>SELECT `jobs`.* FROM `jobs`
  WHERE (interview_date &gt;= '2012-05-03 17:54:41 +0530')
    AND (position like '%ROR%'
      AND category_id = '11'
      AND experience_id = '5' 
      AND interview_address like '%%')
  ORDER BY interview_date asc
  </code></pre>
  
  <p>But for the same query when category_id and experience_id conditions are met I am getting the result.I am totally confused.</p>
  
  <pre><code>SELECT `jobs`.* FROM `jobs`
  WHERE (interview_date &gt;= '2012-05-03 17:55:07 +0530')
    AND (position like '%%'
      AND category_id = '11'
      AND experience_id = '5'
      AND interview_address like '%%')
  ORDER BY interview_date asc
  </code></pre>
  
  <p>I have used AND condition but it returns result when only two conditions are satisfied.
  Am I missing anything here?</p>
  
  <p>Thank you folks.</p>