Re: 'OR' logic in mySQL query

You might want to pattern you SELECT statement in this manner: SELECT * FROM tablename WHERE status = 3 OR status = 1 Notice I called the field name explicitly on each side of the OR. Be sure to check the data type for the date field -- if it is a datetime stamp or date stamp, it might complain with the use of "like" You ought to check out: http://dev.mysql.com/doc/mysql/en/where-optimizations.html Mark Cain ----- Original Message ----- From: "Ron Piggott" <ron.php@actsministries.org> To: "PHP DB" <php-db@lists.php.net> Sent: Sunday, April 17, 2005 4:04 PM Subject: [PHP-DB] 'OR' logic in mySQL query > Am I able to use the OR logic in mySQL queries? > > $query = "SELECT * FROM table WHERE date_received LIKE '$todays_date' OR > '$yesterdays_date' ORDER BY prayer_request_reference ASC"; > > In this above example will the " OR '$yesterdays_date' " work? > > In reality I am wanting to preview new entries to the database within the > past 2 days > > Ron > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >