title: MySQL - How to select a column so that the outcome be a tree structure?
body: <p>If i have a given column with the following snapshot</p>
  
  <pre><code>"A - B - 1"
  "A - B - 2"
  "A - C - 1"
  "A - C - 2"
  "X - B - 1"
  "X - B - 2"
  "X - C - 1"
  "X - C - 2"
  </code></pre>
  
  <p>Which select should I run so that the outcome be</p>
  
  <pre><code>"A",  "", ""
  "", "B", ""
  "",  "", "1"
  "",  "", "2"
  "", "C", ""
  "",  "", "1"
  "",  "", "2"
  "X",  "", ""
  "", "B", ""
  "",  "", "1"
  "",  "", "2"
  "", "C", ""
  "",  "", "1"
  "",  "", "2"
  </code></pre>
  
  <p>Is it possible ?</p>