The where clause is combined with AND , OR and NOT operators.
| Operator | Definition | Example | Result |
|---|---|---|---|
| AND | Returns true if both conditions are true | SELECT * FROM table WHERE column1 = ‘value1’ AND column2 = ‘value2’ | Returns all rows where both column1 is ‘value1’ and column2 is ‘value2’ |
| OR | Returns true if at least one condition is true | SELECT * FROM table WHERE column1 = ‘value1’ OR column2 = ‘value2’ | Returns all rows where either column1 is ‘value1’ or column2 is ‘value2’ |
| NOT | Negates a condition | SELECT * FROM table WHERE NOT column1 = ‘value1’ | Returns all rows where column1 is not ‘value1’ |
example:
|
1 |
select * from cars where model = 'Honda' AND (color='red' OR color='green') |
Output:
