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)? thanks Qianqian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
