title: How to match comma delimited value with other column in mySql
body: <p>I have following two tables:</p>
  
  <p><strong>user:</strong></p>
  
  <pre><code>+---------+--------------+
  | user_id | skills       |
  +---------+--------------+
  |       1 | 1,2,3,5,4,14 |
  |       2 | 1,2,3        |
  |       3 | 3,4,5        |
  |       4 | 1,2          |
  +---------+--------------+
  </code></pre>
  
  <p><strong>pskills:</strong></p>
  
  <pre><code>+-----+--------+------+----------+
  | PID | SKILLS | SPLI | status   |
  +-----+--------+------+----------+
  |   1 | 2,4    |    1 |          |
  |   1 | 1      |    1 | required |
  +-----+--------+------+----------+
  </code></pre>
  
  <p>I want to match values of <strong>SKILLS</strong> columns of table <strong>pskills</strong>. Such as if query is done with first row of <strong>pskills</strong> and join with user table then it will return User ID 1 because SKILLS 2,4 match with user id 1 only. How can i do this easily?</p>