Whenever you are trying to exclude a list, you should use AND, not OR. This is a logic 
issue. However, to make it more exact, streamlined and simpler use the NOT IN clause.

SELECT ... FROM ... WHERE country NOT IN ('Argentina', 'USA', 'Mexico', etc.)



-----Original Message-----
From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent:   Tue 7/20/2004 4:40 PM
To:     [EMAIL PROTECTED]
Cc:     
Subject:        [BULK] - php-db Digest 20 Jul 2004 23:40:15 -0000 Issue 2503

php-db Digest 20 Jul 2004 23:40:15 -0000 Issue 2503

Topics (messages 35403 through 35420):

Re: howto get PK id after INSERT??
        35403 by: Vincent Jordan
        35404 by: Jason Wong
        35405 by: jeffrey_n_Dyke.Keane.com
        35410 by: John W. Holmes

MySQL '!=' ???
        35406 by: Tristan.Pretty.risk.sungard.com
        35407 by: Hutchins, Richard
        35408 by: VANDOORINE A     RsrhCppRfaRva

Re: Wait Statement... ?
        35409 by: John W. Holmes
        35413 by: Daevid Vincent
        35414 by: John W. Holmes
        35415 by: Ignatius Reilly
        35416 by: Pablo M. Rivas
        35417 by: Tim Van Wassenhove
        35418 by: Jason Wong
        35420 by: John W. Holmes

Re: DB table creation question
        35411 by: Swan, Nicole

pg_end_copy error using PHP with PostgreSQL
        35412 by: Robert Fitzpatrick

Concurrent rutines
        35419 by: Luis Morales

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------




Reply via email to