title: MYSQL - Generate string in column 5 with data in columns 1, 2, 3 and 4 - Same Table
body: <p>I would like to understand how to populate column "Summary' with data from columns; Bedrooms, Bathrooms, Prop_type and Location with some additional text in between some of the data</p>
  
  <p>Example:</p>
  
  <pre><code>Bedrooms = 3
  Bathrooms = 2
  Prop_type = Apartment
  Location = Madrid
  </code></pre>
  
  <p>The result I would like to achieve in the column 5 would be;</p>
  
  <p>"Apartment in Madrid with 3 Bedrooms &amp; 2 Bathrooms, Madrid 3 Bed Apartment, 3 Bed &amp; 2 Bathrooms in Marid"</p>
  
  <p>I trust I have (this time) presented my question in an easy to understand format, if I have not I apologise in advance</p>