On Tue, Dec 2, 2014 at 12:46 PM, Paul Sanderson < sandersonforens...@gmail.com> wrote:
> I have a query that returns one column but a number of rows so for instance > > SELECT name from tab > > might return > > a > b > c > d > > I would like to append these terms and get a single line/string > > a_b_c_d > > > I want to just use a single SQL query to do this, is it possible? > SELECT group_concat(name,'_') FROM tab; > > > > > > Paul > www.sandersonforensics.com > skype: r3scue193 > twitter: @sandersonforens > Tel +44 (0)1326 572786 > http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit > -Forensic Toolkit for SQLite > http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC > processing made easy > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
