How to use between and in mysql

In mysql, the "between and" keyword is used for range queries. Two parameters need to be set, namely the starting value and the ending value of the range. The syntax "[NOT] BETWEEN value 1 AND value 2 ". "BETWEEN AND" can match all values ​​within the specified range, including the starting value and the ending value. If the field value is within the specified range, these records will be returned. If they are not within the specified range, they will not be returned.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

MySQL BETWEEN AND

Usage: used for range query

BETWEEN AND requires two Parameters, the starting and ending values ​​of the range. If the field value is within the specified range, these records are returned. If it is not within the specified range, it will not be returned.

The basic syntax format for using BETWEEN AND is as follows:

[NOT] BETWEEN 取值1 AND 取值2

Among them:

NOT: Optional parameter, indicating a value outside the specified range. If the field value does not meet the specified range of values, these records are returned.

• Value 1: Indicates the starting value of the range.

• Value 2: Indicates the end value of the range. The

BETWEEN AND and NOT BETWEEN AND keywords are useful when querying records within a specified range. For example, query the age group and date of birth of students, the salary level of employees, etc.

Usage example of BETWEEN AND

Example 1

Query the age in table tb_students_info The names and ages of students between 20 and 23, the SQL statements and running results are as follows.

mysql> SELECT name,age FROM tb_students_info 
    -> WHERE age BETWEEN 20 AND 23;

The query results include records with student ages 20 and 23, which shows that In MySQL, BETWEEN AND can match all values ​​within the specified range , including the starting value and the ending value.

Example 2

Query the names and ages of students whose ages are not between 20 and 23 in the table tb_students_info. The SQL statement and running results are as follows.

mysql> SELECT name,age FROM tb_students_info 
    -> WHERE age NOT BETWEEN 20 AND 23;

Example 3

Query the registration date in table tb_students_info between 2015-10-01 and 2016-05-01 student information. The SQL statements and running results are as follows.

mysql> SELECT name,login_date FROM tb_students_info
    -> WHERE login_date BETWEEN '2015-10-01' AND '2016-05-01';

[Related recommendations: mysql video tutorial]

The above is the detailed content of How to use between and in mysql. For more information, please follow other related articles on the PHP Chinese website!