sql query for filtering data with where multiple criteria on same column of table

Question

I have following Sample table. table having combination of name and key column unique records

ID   name      key          key_type 
-----------------------------------
118  ab         12          aw1 
119  fb         13          1Y2 
120  cb         14          qw3 
121  ab         15          4123
122  cs         12          23d2

select * from Sample where name ='ab' and key= '12' 

select * from Sample where name ='fb' and key= '13'

how to write single query for both record ?

so whats the problem with the query you are trying?

Vivek Singh
– Vivek Singh

2015-04-30 10:03:06 +00:00
Commented Apr 30, 2015 at 10:03 — Vivek Singh
– Vivek Singh, Commented Apr 30, 2015 at 10:03
WHERE (a AND b) OR (c AND d) should do the trick

Michel
– Michel

2015-04-30 10:36:25 +00:00
Commented Apr 30, 2015 at 10:36 — Michel
– Michel, Commented Apr 30, 2015 at 10:36

Abhik Chakraborty · Accepted Answer · 2015-04-30 10:03:11Z

1

Easiest way would be union all

select * from Sample where name ='ab' and key= '12' 
union all
select * from Sample where name ='fb' and key= '13'

answered Apr 30, 2015 at 10:03

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

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

Comments

pala_ · Accepted Answer · 2015-04-30 10:10:20Z

0

Easiest way would be

select * 
  from Sample 
  where (name = 'ab' and `key` = '12') 
    or (name = 'fb' and `key` = '13')

Demo here: http://sqlfiddle.com/#!9/3eabc/3

Throw an index on (name, key) for good measure.

create index name_key on sample(name, `key`);

answered Apr 30, 2015 at 10:10

pala_

9,0101 gold badge18 silver badges32 bronze badges

Collectives™ on Stack Overflow

sql query for filtering data with where multiple criteria on same column of table

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