Returing all records including duplicated with MySQL IN clause
<p>Assuming both <code>fk</code> equal to 1 and 3 exists in the table, the following query will return two records.</p>

<pre><code>SELECT fk, name FROM my_table WHERE fk IN (1,3,1);
</code></pre>

<p>How can I instead return three records:</p>

<pre><code>fk name
1  john
3  mary
1  john
</code></pre>