title: How to split row into multiple rows from the MySQL?
body: <p>I have a MySQL data table, in which I have more than 2 columns. First column has a unique value clinical trial value whereas second column has disease information. There are, in most of the cases, more than 2 disease names in one cell for a single id. I want to spilt those rows which cell contains two or more than two diseases. There is a pattern for searching also, i.e. small character is immediately followed by capital character., e.g. MalariaDengueTuberculosis like this. Suppose for these three diseases there is unique id, it should show like the following:</p>
  
  <pre><code>      NCT-ID           disease
       4534343654       Maleria
       4534343654       Dengue
       4534343654       Tubercoulsosis
  </code></pre>