title: Order of condition execution in MySQL
body: <p>Suppose I have a MySQL query with two conditions:</p>
  
  <pre><code>SELECT * FROM `table` WHERE `field_1` = 1 AND `field_2` LIKE '%term%';
  </code></pre>
  
  <p>The first condition is obviously going to be a lot cheaper than the second, so I'd like to be sure that it runs first, limiting the pool of rows which will be compared with the LIKE clause. Do MySQL query conditions run in the order they're listed or, if not, is there a way to specify order?</p>