从列中选择具有多个值的条件

Created: November-22, 2018

SELECT * FROM Cars  WHERE status IN ( 'Waiting', 'Working' )

这在语义上等同于

SELECT * FROM Cars  WHERE ( status = 'Waiting' OR status = 'Working' )

即 value IN ( <value list> ) 是析取的简写（逻辑 OR）。