MySql help to write a query
<p>Suppose i have a table with 3 columns like below</p>

<pre><code> ------------------------------
|id | recipe_id | sub_category |
 ------------------------------
| 1 | 80        | 2            |
| 2 | 80        | 6            |
| 3 | 80        | 3            |
| 4 | 82        | 1            |
| 5 | 83        | 2            |
| 6 | 85        | 5            |
| 7 | 80        | 10            |
 ------------------------------
</code></pre>

<p>How can i get the recipe id which contains both sub categories 2 and 6 ??
Is it possible to get it using mysql query?</p>