IN Predicate

noun

say it: “IN PRED-ih-kit” /ɪn ˈprɛdɪkɪt/

A SQL condition that checks whether a value matches any value in a list, like Country IN ('UK', 'USA').

What does IN Predicate do in a relational database?

IN Predicate — A predicate testing whether a value equals any value in a list or subquery result.

SELECT order_id
FROM purchase_order
WHERE status IN ('open', 'processing');

In a sentence

  • “WHERE Country IN ('UK', 'USA') replaced two ORs.”

Level: Apprentice · More SQL terms at this level

Updated