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
>
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.
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.
3 matches
Mail list logo