title: How to get name of comma separated id in mysql?
body: <p>I am using two tables -institute and category. Institute table is having category id with comma separated values like 1,2. I want to get these comma separated values as IT,Health in MySQL query result. </p>
  
  <p><a href="https://i.stack.imgur.com/mOBDE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mOBDE.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/6ljv2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6ljv2.png" alt="enter image description here"></a></p>
  
  <p>I am using this below query:</p>
  
  <pre><code>SELECT i.*, c.category_name FROM institute i, category c WHERE FIND_IN_SET(c.category_id, i.institute_category)
  </code></pre>
  
  <p>Which shows me the below result :</p>
  
  <p><a href="https://i.stack.imgur.com/NhywL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NhywL.png" alt="enter image description here"></a></p>
  
  <p>I am looking for comma separated values in categories and dont need duplicate institute id i.e.</p>
  
  <p><a href="https://i.stack.imgur.com/SdrrV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SdrrV.png" alt="enter image description here"></a></p>