On Tue, 15 Aug 2017, Dan Kennedy wrote:

On 08/15/2017 10:12 PM, Bob Friesenhahn wrote:
select group_concat(name, ' ') AS 'names' from moca_config where enable == 1 order by name;

Maybe this:

select group_concat(name, ' ') AS 'names' from (
 SELECT name FROM moca_config where enable == 1 order by name
);

That does return the expected order.  Was my expectation unreasonable?

Bob
--
Bob Friesenhahn
bfrie...@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,    http://www.GraphicsMagick.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to