title: MySQL LIMIT on multiple categories
body: <p>Given the category name, I'm able to select the number of entries needed.
  For example - <code>SELECT * FROM products WHERE Category = Taxi LIMIT 1, 2</code>.
  This perfectly gives me 2 entries of Category = 'Taxi'.</p>
  
  <p>Now, given an array of Category names, I need to perform a similar sql query, where I'll be able to fetch the required number of entries of each category.</p>
  
  <p><strong>Requirement - I need to fetch all the data of 2 (LIMIT 1, 2) rows of each of categories in ['Taxi', 'Groceries', 'Delivery',  . . . . . . . . . . . ]</strong>, using a single SQL query. Is it possible? If yes, please answer.</p>
  
  <p>I tried this - <code>SELECT * FROM products WHERE Category IN ('Taxi', 'Groceries', 'Delivery',  . . . . . . . . . . . ) LIMIT 1, 2</code>, but it gave the same result as above.</p>
  
  <p>This is how the products table looks like - </p>
  
  <pre><code>+----------+----------+------+
  | Category | Items    | Count|
  +----------+----------+------+
  | Taxi     | Sedan    | 32   |
  | Delivery | Food     | 34   |
  | Delivery | Package  | 42   |
  | Meals    | Sandwitch| 29   |
  | Groceries| Butter   | 36   |
  | Taxi     | SUV      | 39   |
  | Groceries| Milk     | 39   |
  +----------+----------+------+
  </code></pre>
  
  <p>Expected O/P - </p>
  
  <pre><code>+----------+----------+------+
  | Category | Items    | Count|
  +----------+----------+------+
  | Taxi     | Sedan    | 32   |
  | Delivery | Food     | 34   |
  | Delivery | Package  | 42   |
  | Groceries| Butter   | 36   |
  | Taxi     | SUV      | 39   |
  | Groceries| Milk     | 39   |
  +----------+----------+------+
  </code></pre>
  
  <p>Rows order doesn't matter.</p>