Re: SELECT except

[Thimble Smith]

At 13:09, 19990820, toxalot@stripped wrote:
>Is there a way to select all fields from a table except for one?

Um...how do you know which one you don't want?  Do you know the value
of it's primary key, for example?  If so, then just select rows that
don't have that value:

    SELECT xyz FROM tbl WHERE pri_key <> 'the value'

Tim