An operator that checks whether a value matches any item in a specified list.
An operator that checks whether a value matches any item in a specified list, letting multiple OR conditions be written together. Instead of a literal list, it can also take a subquery's result, as in WHERE id IN (SELECT ...) -- but when the result set is large, EXISTS can perform better.
© 2026 ITBGM