“Logical operators” enable us to use more than one condition in WHERE clause. You use the AND “logical operator” to specify that the search must satisfy both …
source
07 MySQL Tutorial for Beginners: Logical Operators (AND, OR, NOT), NULL, IS NULL Clause
One response to “07 MySQL Tutorial for Beginners: Logical Operators (AND, OR, NOT), NULL, IS NULL Clause”
WHERE NOT state='california'; is equal to WHERE state<>'california'; (WHERE state!='california';)?