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
[email protected], http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,    http://www.GraphicsMagick.org/
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to