Querying multiple values from multiple columns in MySQL

Question

I'm trying to query by a list of value pair.

For example:

src   dst   byte
 a     b     16
 c     d     20
 e     f     50
 a     f      0

I want to query by src and dst in one Query to get (a, b, 16) and (e, f, 50).

SELECT *
FROM table
WHERE src IN ( a, e )
AND dst IN (b, f )

But this statement also gives me (a, f, 0).

Is it possible to get (a, b, 16) and (e, f, 50) in one query?

I am wondering if there is any other method besides WHERE src = 'a' AND dst = 'b' OR src = 'e' AND dst = 'f'? — cli130
– cli130, Commented Apr 25, 2014 at 6:40

Hamlet Hakobyan · Accepted Answer · 2014-04-25 05:54:05Z

2

Try this:

SELECT *
FROM table
WHERE src = 'a' AND dst = 'b'
   OR src = 'e' AND dst = 'f'

answered Apr 25, 2014 at 5:54

Hamlet Hakobyan

33.5k6 gold badges55 silver badges70 bronze badges

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

1 Comment

Is there any other option?

Sadikhasan · Accepted Answer · 2014-04-25 05:55:59Z

1

Do simple things like

SELECT *
FROM your_table
WHERE (src = 'a' AND dst = 'b')
   OR (src = 'e' AND dst = 'f');

answered Apr 25, 2014 at 5:55

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges