title: MySQL string functions
body: <p>I have a a table with the following data:</p>
  
  <pre><code>reservno || icode || location
  00004    || 00021 || Bohol - Cebu
  00004    || 00022 || Cebu - Manila
  00004    || 00014 || Manila - Bohol
  </code></pre>
  
  <p>I use this query to retrieve the concatenated value of location.</p>
  
  <pre><code>SELECT GROUP_CONCAT(location) from location_list where reservno='00004';
  </code></pre>
  
  <p>The query result looks like this:</p>
  
  <pre><code>GROUP_CONCAT(location)
  Bohol - Cebu,Cebu - Manila,Manila - Bohol
  </code></pre>
  
  <p>But what I want to do is for the query to look like this: <code>Bohol - Cebu - Manila - Bohol</code>. I would like to merge the result like that. How can I achieve this? I'm not that familiar with MySQL string functions so I need some ideas on how to make this work. Any help will be appreciated. Thanks a lot! </p>