0

Can I combine two mysql query below?

Select * from wp_postmeta where meta_key = '_kpo_shop_order' and meta_value = 1

Select * from wp_postmeta where meta_key = '_kpo_ordered_item' and meta_value = 1233

I tried the following

SELECT * FROM wp_postmeta 
            WHERE 
                ( meta_key = '_kpo_shop_order' AND meta_value = 1 ) OR 
                (meta_key = '_kpo_ordered_item'AND meta_value = 1233 );

the problem with the query above is the "OR" syntax. I want to make it "AND". Basically, I want only two rows or no rows at all.

jameshwart lopez
  • 2,993
  • 6
  • 35
  • 65

0 Answers0