How to use sql statement between

The BETWEEN operator checks whether the value is between two values ​​in the specified range. Syntax: SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2; Purpose: 1. Check whether the value is between two specific values; 2. Filter the values ​​within the specified range; 3. Create a range from one value to another.

SQL statement BETWEEN usage

What is BETWEEN

BETWEEN is a SQL operator that checks whether a value is between two values ​​in a specified range.

grammar

 <code class="sql">SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2;</code>

parameter

• column_name: The column name of the value to be checked.
• value1: Low value of range.
• value2: High value of range.

usage

The BETWEEN operator is used in the following scenarios:

• Check if the value is between two specific values.
• Filter values ​​within the specified range.
• Creates a range from one value to another.

Example

 <code class="sql">SELECT * FROM students WHERE age BETWEEN 20 AND 30;</code>

This returns all student records in the table for ages between 20 and 30 years (including both values).

Notice

• The BETWEEN operator is included, which means that both the low and high values ​​of the range will be included.
• The BETWEEN operator can be used with other operators, such as AND, OR, and NOT.
• If you want to check if the value is only smaller or greater than the specified value, you can use the operator.

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