How to use the logical operators

      WHERE [NOT] search_condition_1 {AND|OR} [NOT] search_condition_2 ...
      

      WHERE categoryID = 1 AND discountPercent = 30
      

      WHERE categoryID = 1 OR discountPercent = 30
      

        NOT listPrice >= 500
      

      WHERE listPrice < 500
      

      SELECT productName, listPrice, discountPercent, dateAdded
      FROM products 
      WHERE dateAdded > '2017-07-01' OR listPrice < 500 
      AND discountPercent > 25;
      

      SELECT productName, listPrice, discountPercent, dateAdded
      FROM products 
      WHERE (dateAdded > '2017-07-01' OR listPrice < 500) 
      AND discountPercent > 25;
      

Description

• You can use the AND and OR logical operators to create compound conditions that consist of two or more conditions. You use the AND operator to specify that the search must satisfy both of the conditions, and you use the OR operator to specify that the search must satisfy at least one of the conditions.
• You can use the NOT operator to negate a condition.
• When MySQL evaluates a compound condition, it evaluates the operators in this sequence: (1) NOT, (2) AND, and (3) OR. You can use parentheses to override this order of precedence or to clarify the sequence in which the operations will be evaluated.