MySQL query problem with Bool

Question

I have a problem with the following MySQL query:

SELECT * FROM TPDSessions  WHERE  TPDS_Morning = 0 AND TPDD_Id = 1 AND TPDS_Chair1_idPerson = 16785 OR TPDS_Chair2_idPerson = 16785

The row returned has TPDS_Morning with a value of 1 in it, and I don't get why. This is the table structure:

CREATE TABLE `TPDSessions` (
  `TPDS_Id` int(11) NOT NULL auto_increment,
 `TPDR_Id` int(32) NOT NULL,
 `TPDD_Id` int(32) NOT NULL,
 `TPDS_Morning` tinyint(1) NOT NULL,
 `TPDS_Name` varchar(200) NOT NULL,
 `TPDS_Chair1_idPerson` int(11) NOT NULL,
`TPDS_Chair2_idPerson` int(11) NOT NULL,   
 PRIMARY KEY  (`TPDS_Id`), 
KEY `chair1_idPerson` (`TPDS_Chair1_idPerson`,`TPDS_Chair2_idPerson`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

If anyone can explain how to adjust my query to not return that result...

The magic word is ‘precedence’. dev.mysql.com/doc/refman/5.0/en/operator-precedence.html — bobince
– bobince, Commented Feb 13, 2010 at 13:18

Adriaan Stander · Accepted Answer · 2010-02-13 13:14:56Z

2

You might be missing some brackets with the OR statement.

It could be either

SELECT  * 
FROM    TPDSessions  
WHERE   (TPDS_Morning = 0 
AND     TPDD_Id = 1 
AND     TPDS_Chair1_idPerson = 16785) 
OR      TPDS_Chair2_idPerson = 16785

SELECT  * 
FROM    TPDSessions  
WHERE   TPDS_Morning = 0 
AND     TPDD_Id = 1 
AND     (TPDS_Chair1_idPerson = 16785 
OR      TPDS_Chair2_idPerson = 16785)

I think the second is more likely what you are after.

answered Feb 13, 2010 at 13:14

Adriaan Stander

167k32 gold badges294 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vinko Vrsalovic Over a year ago

Yes, given the question the second one is very likely

Maarten Over a year ago

argh..yes that's it. Thanks for clearing that up, had this problem before but not often enough apparently to notice it this time. Thanks!

Vinko Vrsalovic · Accepted Answer · 2010-02-13 13:15:10Z

1

Because you have an OR at the end. There could be a row with Chair2_idPerson = 16875 and with TDPS_Morning = 1. Place brackets where appropriate to group the statements.

answered Feb 13, 2010 at 13:15

Vinko Vrsalovic

342k55 gold badges341 silver badges374 bronze badges

Collectives™ on Stack Overflow

MySQL query problem with Bool

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related