title: Concatenate multiple rows in single rows in MySQL
body: <p>How can I concatenate all the rows in single rows when I fire SELECT query?</p>
  
  <p><img src="https://i.stack.imgur.com/2XyJC.png" alt="enter image description here"></p>
  
  <p>I want O/P like</p>
  
  <p>101 abc CA USA 102 xyz PH UK 103 pqr WDC EU</p>
  
  <p>Any help kindly appreciated. Thanks</p>