Answers for "sql multiple and in where"

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 "sql multiple and in where"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql multiple and in where"

Code answers related to "sql multiple and in where"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql multiple and in where"

Code answers related to "sql multiple and in where"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us