var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MySQL: Group Concat using Single Quotes as a Separator
I'm trying to add a single quote around each username when it spits out the results. The closest thing I got was this:
SELECT GROUP_CONCAT(username SEPARATOR "','" ) AS Usernames FROM auth;
It worked and it added a single quote around each username EXCEPT for the first and last username on the list. Does anyone know how to fix this?
Thank you for the help.
1. i bet i know why you're doing this, and as the kids say these days, "ur doin it wrong"
2. here's your extra quotes around them all --
SELECT CONCAT("'",GROUP_CONCAT(username SEPARATOR "','"),"'") AS ...