sql where clause multiple values code example

Example 1: 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

Example 2: sql where multiple values

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

Example 3: in condition in sql

IN condition allows you to easily test
if an expression matches any value
in a list of values.
It is for reducing  multiple OR
conditions in a SELECT, INSERT, 
UPDATE, or DELETE statement.

Tags:

Sql Example

Related