title: MYSQL Multiple rows of same table to result in multiple columns depending on the criteria
body: <p><a href="http://sqlfiddle.com/#!2/08fab" rel="nofollow noreferrer"><h2>Schema at Fiddle</h2></a></p>
  
  <p>Result to be:
  I want to get the records who has msr_name either 'PRE' OR 'POST' or BOTH</p>
  
  <pre><code>id  |  msr_name1(only pre)   |  msr_data1(only pre)  |  msr_name2(only post)   |  msr_data2(only post)
  
  16703      PRE                            pre_data                              POST                              post_data
  
  16711      PRE                            pre_data                              NULL                              NULL
  
  16715      NULL                            NULL                                 POST                              post_data
  </code></pre>