title: How to find unique values from a column that has multiple values separated by space in mysql
body: <p>How to find unique values from a column that has multiple values separated by a space.</p>
  <p>For example, I have four categories namely A, B, C and D. First two rows have the categories A, B and C and last two rows have categories B, C and D.</p>
  <pre><code>Categories
  
  ----------
  
  A B C
  A B C
  B C D
  B C D
  </code></pre>
  <p>I want to get the unique values which are A, B, C, D</p>
  <p>But if I write the following query it will give me the following result which is not desired:</p>
  <pre><code>SELECT DISTINCT categories from table
  
  Categories:
  
  A B C
  B C D
  </code></pre>
  <p>Desired result is following:</p>
  <pre><code>Categories
  
  -----------------
  
  A
  B
  C
  D
  </code></pre>