Re: SELECT query with multiple "WHERE" Clause

From: Date: Thu, 28 Feb 2008 00:14:29 +0000
Subject: Re: SELECT query with multiple "WHERE" Clause
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-44684@lists.php.net to get a copy of this message
Greg Bowser wrote:
In MySQL, both "OR" and "||" are valid logical or operators. You can only have one Where clause, thus your last example is correct.
Though in postgresql and db2 (and some other dbs) "||" means "concatenate" so stick with using the word "OR" in this situation otherwise you'll run into portability issues if you ever needed to move to another db. -- Postgresql & php tutorials http://www.designmagick.com/

« previous php.db (#44684) next »