title: Priority of AND and OR operator in Mysql select query
body: <p>I have a written a <code>mysql select query</code> to fetch schedule details based on origin states,origin city,destination state and destination city. In my query i have used <code>AND</code> and <code>OR</code> operator.</p>
  
  <p>Here is my query,</p>
  
  <pre><code>SELECT * FROM TruckLoadSchedule ts 
  WHERE ts.originState IN (states) AND ts.originCity IN (cities) 
     OR ts.destState IN (states) AND ts.destCity IN (cities);
  </code></pre>
  
  <p>But I need to know the priority of AND and OR operator in the above query, i mean to say will it do something like this <code>(X AND Y) OR (M AND Q)</code> internally?</p>