Is there an equal sign in the between statement in mysql?

There is no equal sign in the between statement in mysql. The syntax format of between: [[NOT] BETWEEN value 1 AND value 2]. The BETWEEN AND keyword is used to determine whether the value of a field is within the specified range.

Range query with BETWEEN AND in MySQL data table

(Recommended tutorial: mysql video tutorial)

BETWEEN AND keyword can determine whether the value of a field is within the specified range.

If the value of the field is within the specified range, the query conditions are met and the record will be queried.

If the value of the field is not within the specified range, the query conditions are not met.

The basic syntax format is as follows:

[NOT] BETWEEN 取值1 AND 取值2

NOT: Optional. Adding NOT indicates that the conditions in the specified range cannot be met.

Value 1: Indicates the starting value of the range.

Value 2: Indicates the end value of the range.

Note:

Includes boundaries, as follows: between...prar1 and prar2 is equivalent to >=prar1 and <=prar2;

The above is the detailed content of Is there an equal sign in the between statement in mysql?. For more information, please follow other related articles on the PHP Chinese website!