February 22, 2017

How to get SQL group_concat comma separated value sort in ASC/DESC order?



- Here is simple example to explain how to get group concat comma seprated value into order by

Example :

SELECT field1,
  GROUP_CONCAT(first_name ORDER BY first_name ASC SEPARATOR ',')
  FROM tablename

Enjoy!

1 comment:

Integrating Google reCAPTCHA v3 in HTML Form with PHP

  What is Google reCAPTCHA v3? Google reCAPTCHA is a free service that helps protect websites from spam and abuse. reCAPTCHA v3 is the lates...