MySQL: difference of two result sets

Posted by Zombies on Stack Overflow See other posts from Stack Overflow or by Zombies
Published on 2010-04-27T18:19:53Z Indexed on 2010/04/27 18:23 UTC
Read the original article Hit count: 210

Filed under:
|

How can I get the set difference of two result sets?

Say I have a result set (just one column in each):

result1:
'a'
'b'
'c'

result2:
'b'
'c'

I want to minus what is in result1 by result2: result1 - result2 such that it equals:

 difference of result1 - result2:
 'a'

© Stack Overflow or respective owner

Related posts about mysql

Related posts about set-difference