MySQL Tutorial

A database system used with PHP.

Chapter Quiz Exercises
Course Topics
MySQL Intro MySQL SELECT MySQL SELECT DISTINCT MySQL WHERE MySQL ORDER BY MySQL AND, OR, NOT MySQL INSERT INTO MySQL NULL Values MySQL UPDATE MySQL DELETE MySQL LIMIT MySQL MIN() and MAX() MySQL COUNT(), AVG(), SUM() MySQL LIKE MySQL IN MySQL BETWEEN MySQL Aliases MySQL INNER JOIN MySQL LEFT JOIN MySQL RIGHT JOIN MySQL GROUP BY MySQL HAVING MySQL Create DB MySQL Drop DB MySQL Create Table MySQL Drop Table MySQL Alter Table MySQL Constraints MySQL Auto Increment MySQL Views

MySQL BETWEEN

The MySQL BETWEEN Operator

The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.

The BETWEEN operator is inclusive: begin and end values are included.

Syntax:

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Try It Yourself

Edit the code below and click Run to see the result live.

Source Code
Result
Topics
MySQL Intro MySQL SELECT MySQL SELECT DISTINCT MySQL WHERE MySQL ORDER BY MySQL AND, OR, NOT MySQL INSERT INTO MySQL NULL Values MySQL UPDATE MySQL DELETE MySQL LIMIT MySQL MIN() and MAX() MySQL COUNT(), AVG(), SUM() MySQL LIKE MySQL IN MySQL BETWEEN MySQL Aliases MySQL INNER JOIN MySQL LEFT JOIN MySQL RIGHT JOIN MySQL GROUP BY MySQL HAVING MySQL Create DB MySQL Drop DB MySQL Create Table MySQL Drop Table MySQL Alter Table MySQL Constraints MySQL Auto Increment MySQL Views