Re: [sqlite] match on single column but with multiple value

That's great Mike. Thanks very much! On 10 February 2013 20:26, Mike King 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 >

Re: [sqlite] match on single column but with multiple value

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.

[sqlite] match on single column but with multiple value

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.