title: Multiple WHERE with LIMIT MySQL
body: <p>Using PHP, is it possible to select multiple rows from one table, in a MySQL database, with different WHERE clauses having a specific LIMIT for each WHERE clause.</p>
  
  <p>For example:</p>
  
  <pre><code>SELECT * FROM the_table WHERE color = 'blue' LIMIT 5 OR color = 'red' LIMIT 10
  </code></pre>
  
  <p>I know the above statement does not work. But is there a way to do this with a single call to the database?</p>