Re: interval query.

Try

SELECT * FROM Towns WHERE id=9999 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
> 9999    Tallinn
> 3       Tallinn/Haabersti
> 4       Tallinn/Mustamae
>         ...
> etc.
> 
> What I need is when the town's id=9999 I want to make query
> where id=9999 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?
> 
> Greetings,
>         Antti