Mysql query filter results

Question

i don't find a solution for this and need a good tip.

This is the table:

Name,Status
A, 3
A, 4
B, 3

I like do get all results where Status is like 3 but never got Status=4.

In this example: only B should be shown. How should my query look like? Thank you!!

This would also show "A"- But A also has an entry status =4. And should not be shown. I like to see only the ones, who have not an entry =3 AND =4. Only the ones which have 3 only. — Sandy
– Sandy, Commented Jul 2, 2018 at 10:22
so yes it will give results where status is only 3. if you want to get want to you need to chnage your query select * from table where name ='A'; it will give status 3 and 4 as well — Salman Zafar
– Salman Zafar, Commented Jul 2, 2018 at 10:24

Jaydip Jadhav · Accepted Answer · 2018-07-02 10:24:28Z

1

Try this :

Select t1.* 
from tableName t1
where t1.status =3 AND NOT EXISTS (SELECT 1 
                                   FROM TableName t2
                                   WHERE t1.Name = t2.Name AND t2.status = 4)

answered Jul 2, 2018 at 10:24

Jaydip Jadhav

12.3k6 gold badges26 silver badges41 bronze badges

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

Comments

Paul Spiegel · Accepted Answer · 2018-07-02 11:18:10Z

0

select t.Name
from my_table t
where t.Status in (3,4)
group by t.Status
having group_concat(t.Status) = '3'

answered Jul 2, 2018 at 11:18

Paul Spiegel

31.9k5 gold badges48 silver badges56 bronze badges

Collectives™ on Stack Overflow

Mysql query filter results

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