On Tue, Jan 12, 2010 at 3:12 PM, Qianqian Fang <fan...@gmail.com> wrote: > On 1/12/2010 4:08 PM, Jay A. Kreibich wrote: >> SELECT group_concat( value ) FROM mydata WHERE id IN ( 'id_1', 'id_2', ... ) >> > > hi Jay > > thank you very much for your quick response. I guess this will be > significantly faster than looping through each id. > > One more question, will this work if you have a long list of ids (say > a few hundred)? >
try it. It won't hurt, and it will be the best way to answer your own question. -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users