MySQL query with multiple where clauses

Question

I have a table wp_postmeta with columns called meta_key and meta_value. I have 5 records in meta_key (location,area,price,bedrooms,bathrooms)

For example, I want to find a hotel in Texas with 2 bathrooms:

select post_id from wp_postmeta where meta_key = 'location' and meta_value = 'texas' and where meta_key = 'bathrooms' and meta_value= '2';

I know the above SQL command is not valid. Can anyone please help me to achieve the above result?

Korhan Ozturk · Accepted Answer · 2012-08-12 21:53:52Z

4

You can try mysql subquery:

select post_id 
from wp_postmeta 
where meta_key = 'location' and meta_value = 'texas' 
                  and post_id IN (select post_id 
                  from wp_postmeta 
                  where meta_key = 'bathrooms' and meta_value= '2')

edited Aug 12, 2012 at 21:53

Korhan Ozturk

11.3k6 gold badges38 silver badges50 bronze badges

answered Aug 12, 2012 at 7:02

while1

3,37022 silver badges12 bronze badges

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

1 Comment

Shameer Rahman Over a year ago

awesome its working... but i did small correction it should be select post_id from wp_postmeta where meta_key = 'location' and meta_value = 'texas' and post_id IN (select post_id from wp_postmeta where meta_key = 'bathrooms' and meta_value= '2'), rest works like charm, thanks alot :)

Collectives™ on Stack Overflow

MySQL query with multiple where clauses

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related