Does mysql between and contain boundaries?

Mysql data query statement between and contains boundary values

MySQL You can use between in sql statements to limit the range of a data, for example:

select * from user where userId between 5 and 7;

Query users whose userIds are 5, 6, and 7. The userId range includes boundary values, which is also equivalent to the following query:

select * from user where userId >= 5 and userId 9b4a1e288cc9ada0e7e6dd69d7e2d9e0= and <= to specify the conditions.

In addition, the range of not between does not include boundary values.

Recommended tutorial: "mysql tutorial"

The above is the detailed content of Does mysql between and contain boundaries?. For more information, please follow other related articles on the PHP Chinese website!