title: SQL beginer query that split string
body: <p>I have a column :
  That contains a lot of world like this : beetween ";"</p>
  
  <p>I want to be able to locate where is ";"</p>
  
  <pre><code>1; 2; 3;
  </code></pre>
  
  <p>Example :</p>
  
  <pre><code>SELECT DISTINCT SUBSTRING_INDEX(`col1`, ';',+1)
  </code></pre>
  
  <p>I'll get the first one but i am not able to get only the 2nd or the 3rd
  if i do +2 
  i'll get : 1 2  and i want only 1 or 2</p>