Hi,
where id= or id between 3 and 12;
or
where id in (3,4,5,6,7,8,9,10,11,12,);
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.ipinc.com
On Wed, 31 Jan 2001, Antti Linno wrote:
> Good morning.
Try
SELECT * FROM Towns WHERE id= OR id BETWEEN 3 AND 12
Antti Linno wrote:
>
> Good morning.
>
> Is there some way to make interval query?
>
> Towns table(estonia towns, heh :P)
>
> id | name
>
> 1 Elva
> 2 Tartu
> Tallinn
> 3 Tallinn/Haabersti
> 4 Tall
> Is there some way to make interval query?
>
> What I need is when the town's id= I want to make query
> where id= OR id=[3..12] for example. I could generate bunch of OR's
> like id=3 OR id=4 ... but is there some more elegant solution?
>
This should work : WHERE id = OR id BETW
Good morning.
Is there some way to make interval query?
Towns table(estonia towns, heh :P)
id | name
1 Elva
2 Tartu
Tallinn
3 Tallinn/Haabersti
4 Tallinn/Mustamae
...
etc.
What I need is when the town's id= I want to make query
where id= OR id=
