SQLite Forum

How to cancatenate all lines in table to a single string?
Just a note that I do not believe that you can explicitly order group_concat() in SQLite. So if you need it to be in a specific order: 'Line1 Line2 Line3' then you'll have to use something else as you might get 'Line3 Line2 Line1'. If arbitrary ordering is fine, then yes, use group_concat()