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: php-db-digest-help@xxxxxxxxxxxxx [mailto:php-db-digest-help@xxxxxxxxxxxxx]
Sent: Tue 7/20/2004 4:40 PM
To: php-db@xxxxxxxxxxxxx
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:
php-db-digest-subscribe@xxxxxxxxxxxxx
To unsubscribe from the digest, e-mail:
php-db-digest-unsubscribe@xxxxxxxxxxxxx
To post to the list, e-mail:
php-db@xxxxxxxxxxxxx
----------------------------------------------------------------------
