MySQL SELECT If Statement WHERE Condition

Question

I created a module for rendering overtime. In the module you will select your approving person and it will be maximum of 3 persons.

The scenario is that I will display all approved overtimes if manager1_date is not NULL, manager2_date is not NULL and manager3_date is not NULL. But as i said, it can be only 1,2 or 3 approving person. what if i applied then i have only 2 approving persons, it should be if manager1_date is not NULL and manager2_date is not NULL.

I tried this query:

Select * from table1 
where manager1_date is not null 
AND (manager2_date is not null or manager3_date is not null)

In PHP, it displays the record but the record has 3rd approving person which is manager3_date is NULL. it should not display the record until the approving persons are filled out.

Could I ask what is the difference? What do you mean by //no selection? — Hass
– Hass, Commented Nov 8, 2013 at 3:13
Is there a reason you're SHOUTING your question here? Apparently your CAPS lock is not stuck. Do you think typing your question IN ALL CAPS will get you an answer more quickly? (The answer to that is no, BTW.) — Ken White
– Ken White, Commented Nov 8, 2013 at 3:23

AllInOne · Accepted Answer · 2013-11-08 03:26:41Z

1

I think you are saying that all three managers must approve. If so your query would be:

SELECT *
FROM table1 
WHERE manager1_date IS NOT null 
AND manager2_date IS NOT null 
AND manager3_date IS NOT null

answered Nov 8, 2013 at 3:26

AllInOne

1,4502 gold badges14 silver badges32 bronze badges

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

Comments

Tom · Accepted Answer · 2013-11-08 03:26:17Z

0

I'm not sure if I understand your question, but if you need to see when all three manager dates are not null, get rid of the "or".

Select * 
from   table1 
where  manager1_date is not null 
       AND manager2_date is not null 
       AND manager3_date is not null

answered Nov 8, 2013 at 3:26

Tom

6,6633 gold badges24 silver badges42 bronze badges

Collectives™ on Stack Overflow

MySQL SELECT If Statement WHERE Condition

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related