Laravel working out with multiple data in a column
<p>I am working on a laravel base profiling system.</p>

<p>Example tables..</p>

<p><strong>Person</strong></p>

<pre><code>id | Name   | sports_id
1  | foo    | 1,2
2  | bar    | 2,3
3  | derp   | 1,3
</code></pre>

<p><strong>Sports</strong></p>

<pre><code>id | Name       |
1  | basketball |
2  | volleyball |
3  | swimming   |
</code></pre>

<p>Question:</p>

<p><strong>How can I get all <code>Name</code> records from <code>Person</code> table, which have <code>sports_id</code> corresponding to value <code>basketball</code> only from <code>Sports</code> table?</strong></p>

<p>Because I'm confused on how to execute the query such as above due to the <code>Person</code> table is not normalized.</p>

<p>Or</p>

<p><strong>Is there a way to normalize the <code>Person</code> table, so that I can query properly?</strong></p>