MySQL BETWEEN AND Operator
MySQL BETWEEN AND Operator
The MySQL BETWEEN ... AND ...
operator is used to filter records within a specified range. This operator is essential for querying data that falls between two values, inclusive.
Syntax
SELECT column1, column2, ...
FROM table_name
WHERE column1 BETWEEN value1 AND value2;
The BETWEEN ... AND ...
operator has the following components:
column1, column2, ...
: The columns to be retrieved.table_name
: The name of the table from which to retrieve the data.column1 BETWEEN value1 AND value2
: The condition to filter the records, wherecolumn1
is within the range ofvalue1
andvalue2
, inclusive.
Example MySQL BETWEEN AND Operator
Let's look at some examples of the MySQL BETWEEN ... AND ...
operator:
Step 1: Using the Database
USE mydatabase;
This query sets the context to the database named mydatabase
.

Step 2: Creating a Table
Create a table to work with:
CREATE TABLE employees (
id INT AUTO_INCREMENT PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
department VARCHAR(50),
salary DECIMAL(10, 2)
);
This query creates a table named employees
with columns for id
, first_name
, last_name
, department
, and salary
.

Step 3: Inserting Initial Rows
Insert some initial rows into the table:
INSERT INTO employees (first_name, last_name, department, salary)
VALUES ('John', 'Doe', 'HR', 50000.00),
('Jane', 'Smith', 'IT', 60000.00),
('Jim', 'Brown', 'IT', 55000.00),
('Jake', 'White', 'HR', 52000.00),
('Jill', 'Green', 'Marketing', 45000.00);
This query inserts five rows into the employees
table.

Step 4: Using BETWEEN AND with WHERE Clause
Use the BETWEEN ... AND ...
operator to filter records based on a range:
SELECT *
FROM employees
WHERE salary BETWEEN 50000 AND 60000;
This query retrieves all columns from the employees
table where the salary
is between 50000 and 60000, inclusive.

Step 5: Using BETWEEN AND with Multiple Conditions
Use the BETWEEN ... AND ...
operator with multiple conditions:
SELECT *
FROM employees
WHERE department = 'IT' AND salary BETWEEN 50000 AND 60000;
This query retrieves all columns from the employees
table where the department
is 'IT' and the salary
is between 50000 and 60000, inclusive.

Conclusion
The MySQL BETWEEN ... AND ...
operator is a powerful tool for filtering records within a specified range. Understanding how to use the BETWEEN ... AND ...
operator is essential for effective data querying and analysis in MySQL.