RE: MySQL '!=' ???
| From: | Jensen, Kimberlee | Date: | Tue, 20 Jul 2004 23:52:53 +0000 |
| Subject: | RE: MySQL '!=' ??? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35421@lists.php.net to get a copy of this message | ||
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@lists.php.net [mailto:php-db-digest-help@lists.php.net]
Sent: Tue 7/20/2004 4:40 PM
To: php-db@lists.php.net
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@lists.php.net
To unsubscribe from the digest, e-mail:
php-db-digest-unsubscribe@lists.php.net
To post to the list, e-mail:
php-db@lists.php.net
----------------------------------------------------------------------