Multiple select ?
| From: | Dave Carrera | Date: | Thu, 01 Aug 2002 09:06:58 +0000 |
| Subject: | Multiple select ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20946@lists.php.net to get a copy of this message | ||
Hi All
I have a situation where I need to do select on my mysql db.
Here is what I am trying to do
Select * from table_name where col1=1 and col2=1 and col3=0
But this refuses to work.
If I change the above to this.
Select * from table_name where col1=1 OR col2=1 and col3=0
What I get is all rows whether or not col3 is 0 or 1.
I am confused ☹
Any help or guidance is very much appreciated.
Thanks in advance
Dave C