android - DISTINCT values with ", " divider in GROUP_CONCAT -


group_concat(g_value,", ") 

this gives me values [comma]+[space] divider

apple, orange, banana, apple, apple

group_concat(distinct g_value) 

this gives me distinct values "," divider without space.

apple,orange,banana

how distinct values ", " divider?

apple, orange, banana

correct syntax is

group_concat( distinct g_value separator ', ') 

Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -