MySQL Between and Not Between Operators:
MySQL Between Operator is a logical operator that allows you to specify whether a value is in a range or not. The BETWEEN operator is often used in the WHERE clause of the SELECT, UPDATE, and DELETE statements.
(1) Syntax of MySQL Between Operator:
| SELECT * FROM table_name WHERE age BETWEEN val1 AND val2 |
(2) Syntax of MySQL Not Between Operator:
| SELECT * FROM table_name WHERE age NOT BETWEEN val1 AND val2 |
Comments (No)