Answers for "multiple where condition in sql"

multiple where statements sql

SELECT items.* FROM items i, meta_data m1, meta_data m2
    WHERE i.item_id = m1.item_id and i.item_id = m2.item_id
    AND m1.meta_key = 'lat' AND m1.meta_value >= 55 AND m1.meta_value <= 65
    AND m2.meta_key = 'lng' AND m2.meta_value >= 20 AND m2.meta_value <= 30

Posted by: Guest on May-03-2020

Code answers related to "multiple where condition in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "multiple where condition in sql"

Code answers related to "multiple where condition in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "multiple where condition in sql"

Code answers related to "multiple where condition in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us