Search comma separated string using LIKE in mysql
<p>I have a table with 3 columns something like below,</p>

<p><strong>expert table</strong></p>

<pre><code>id        - 1589 
name      - Jhonny 
expert_in - 1,12,8 (Values similar like this)
</code></pre>

<p>The experts_in contains another table's foreign key<br></p>

<p><strong>experts_in table</strong><br></p>

<pre><code>id        - 1
expert_in - painting
</code></pre>

<p>I want search experts who are expert in some jobs while searching for experts </p>

<pre><code>SELECT * FROM `experts` WHERE expert_in LIKE 1%
</code></pre>

<p>The above query brings all experts with 11,12,13...etc. I want only exact word. I know LIKE will bring all. Is there any way to achieve this without altering table. <br>Thanks in advance.</p>