MySQL BETWEEN

MySQL Tutorial

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection

« Previous Next »

The BETWEEN operator selects values within a certain range.

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

The values can be numbers, text, or dates.


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

Let's put these statements into real use.

We've a table named Students in our database that contains the following records:

Now lets select values in a certain range from Students table.


SELECT * FROM Students
WHERE ROLL_NO BETWEEN 2 AND 5;

The above MySQL statement selects all students that their ROLL_NO is BETWEEN 2 and 5.

Now lets select values in a outside the range from Students table.


SELECT * FROM Students
WHERE ROLL_NO NOT BETWEEN 2 AND 5;

The above MySQL statement selects all students that their ROLL_NO is NOT BETWEEN 2 and 5.

ROLL_NO	NAME	SUBJECT
1	Will	JAVA
6	Lara	JAVA

« Previous Next »

MySQL - BETWEEN and NOT BETWEEN