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