You have to do it manually. Or reconsider your database schema towards normalization.
Pavel On Fri, Apr 30, 2010 at 10:28 AM, David Lyon <[email protected]> wrote: > If I had a table called TABLE with fields P1N......P50N is there a way to > select something like: > > "select P%N from TABLE" > > to return all the results from columns P1N......P50N or do I have to do it > manually: > > "select P1N, P2N, P3N, P$nN from TABLE" > > I can obviously do it via scripting but wanted a more elegant way. > > Thanks for your help in advance. > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
