That's great Mike. Thanks very much!
On 10 February 2013 20:26, Mike King <[email protected]> wrote:
> Select * from tbl where col1 in ('a', 'b', 'c')
>
>
>
> On Sunday, 10 February 2013, e-mail mgbg25171 wrote:
>
> > Sorry if this is a very basic question but I'm just wondering if there's
> a
> > more elegant way of doing this
> >
> > select * from tbl where col1 = 'a' or col1 = 'b' or col1 = 'c'
> >
> > i.e. selecting rows if a particular column has one of SEVERAL values.
> >
> > Any help much appreciated.
> > _______________________________________________
> > sqlite-users mailing list
> > [email protected] <javascript:;>
> > 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
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
