CODEWITHSUNDEEP
mysql
user2120569
user2120569

Reputation: 235

Merge two SELECT with different WHERE in MySQL

Is there a way to merge this two queries?

SELECT * FROM OFF WHERE New = 0 AND Saw = 1 AND El = 0
SELECT * FROM OFF WHERE New = 1 AND Saw = 0 AND El = 0

If I use this query:

SELECT * FROM OFF WHERE New = 0 AND Saw = 1 AND El = 0 AND New = 1 AND Saw = 0 AND El = 0

I have obviously others result as expected.

Thank you!

Upvotes: 0

Views: 89

Answers (2)

John Woo
John Woo

Reputation: 263743

use OR when grouping these conditions,

SELECT * 
FROM   `OFF`
WHERE  (New = 0 AND Saw = 1 AND El = 0) OR 
       (New = 1 AND Saw = 0 AND El = 0)

Upvotes: 1

funtime
funtime

Reputation: 627

You can always merge any two queries using UNION

(SELECT * FROM OFF WHERE New = 0 AND Saw = 1 AND El = 0)
UNION
(SELECT * FROM OFF WHERE New = 1 AND Saw = 0 AND El = 0)

Upvotes: 0

Related Questions