Answers for "how to use where clause in sql for multiple values at once"

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

sql where multiple values

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

Posted by: Guest on July-29-2020

Code answers related to "how to use where clause in sql for multiple values at once"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to use where clause in sql for multiple values at once"

Code answers related to "how to use where clause in sql for multiple values at once"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to use where clause in sql for multiple values at once"

Code answers related to "how to use where clause in sql for multiple values at once"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us