title: How to split string into multiple rows in a table using MYSQL?
body: <p>I have a table with Four different columns. Its called Box Table. It contains characteristics of different boxes. </p>
  
  <p>Following are the names of the columns: Serial Number, Box Height, Box Width, Box Weight. </p>
  
  <p>The first column (Serial Number) is a string, but it can contain multiple boxes in a single row e.g: (212,234). If a string contains multiples boxes, I want to split that string into different rows (the number of boxes, determined by number of commas + 1). When I do this, I want other column values to replicate for the newly created row(s) as well. e.g </p>
  
  <pre><code>Serial Number: 1,2 | Box Height: 5 | Box Width: 2 | Box Weight: 100
  </code></pre>
  
  <p>After transformation:</p>
  
  <pre><code>Row (1): Serial Number: 1 | Box Height: 5 | Box Width: 2 | Box Weight: 100
  Row (2): Serial Number: 2 | Box Height: 5 | Box Width: 2 | Box Weight: 100 
  </code></pre>
  
  <p>I cannot understand how to even begin this problem. The most I can do is remove the special characters from the string.</p>