Apart from in a query?

[7724]

Hello

I have what seems a very silly question but don't know the answer

If i have a query

Select * from tble where id > 0 AND id < 20

How would Isay within those parameters but Apart from where id == 55?
Cheers

[kostis12345]

Do you mean that you need id to be between 0 and 20 or 55 ?

[7724]

Basically I want to output all the id's between 1 and 20 but also 55.

Thanks

[dagon]

Select * from table where (id > 0 AND id < 20) and id =55

[Weedpacket]

dagon's got a bit of a typo; it should be "...or id=55".

And if you want to get ID 20 as well, then you'd need to change "<20".

[dagon]

yup, thanks weedy. :-)