I have a a table with the following data:
reservno || icode || location 00004 || 00021 || Bohol - Cebu 00004 || 00022 || Cebu - Manila 00004 || 00014 || Manila - Bohol
I use this query to retrieve the concatenated value of location.
SELECT GROUP_CONCAT(location) from location_list where reservno='00004';
The query result looks like this:
GROUP_CONCAT(location) Bohol - Cebu,Cebu - Manila,Manila - Bohol
But what I want to do is for the query to look like this:
Bohol - Cebu - Manila - Bohol. 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!