List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 20 1999 5:43pm
Subject:Re: SELECT except
View as plain text  
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
Thread
SELECT excepttoxalot20 Aug
  • Re: SELECT exceptThimble Smith20 Aug
    • Re: SELECT excepttoxalot20 Aug
      • Re: SELECT exceptjeremy brand20 Aug
        • Re: SELECT excepttoxalot20 Aug
          • Re: SELECT exceptThimble Smith20 Aug