title: MySQL LIKE statement returning odd results
body: <p>When I do a LIKE MySQL query with multiple columns using AND and OR my filter results in the query such as by Price 0 AND 50000 stop working. If I take off the OR from my LIKE statement the search works fine. How do I properly search multiple columns using a LIKE statement?</p>
  
  <p>Here is an example of none working statement where Price is ignored</p>
  
  <pre><code>SELECT * 
    FROM table 
   WHERE Price BETWEEN 0 AND 500000 
     AND class_id = 1 
     AND TotalSqFt BETWEEN 0 AND 999999999 
     AND Acres BETWEEN 0 AND 999999999 
     AND InclusionsFeatures LIKE '%horse%' 
      OR Remarks LIKE '%horse%' 
  ORDER 
      BY Price DESC
  </code></pre>
  
  <p>This statement works correctly but now I can only do a LIKE query on one column.</p>
  
  <pre><code>SELECT * FROM table WHERE Price BETWEEN 0 AND 500000 AND class_id = 1 AND TotalSqFt BETWEEN 0 AND 999999999 AND Acres BETWEEN 0 AND 999999999 AND InclusionsFeatures LIKE '%horse%' ORDER BY Price DESC
  </code></pre>