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/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php