SQL BETWEEN OPERATOR
The SQL BETWEEN OPERATOR is used in a WHERE clause to select a range of data between two values.
SQL BETWEEN OPERATOR Syntax
SELECT “column_name(s)”
FROM “table_name”
WHERE “column_name”
BETWEEN “value1″ AND “value2″
FROM “table_name”
WHERE “column_name”
BETWEEN “value1″ AND “value2″
Now you know the syntax let me show you an example.
SQL BETWEEN OPERATOR Example
To demonstrate the above example assume that we have the following table called Games
| ID | Title | Release Date | Genres | Platform |
|---|---|---|---|---|
| 1001 | GTA IV | April 29, 2008 | Action-adventure | PS3,XBOX360 |
| 1002 | Gran Turismo 5 | November 24, 2010 | Racing | PS3 |
| 1003 | Assassin’s Creed | November 14, 2007 | Third person | PS3,XBOX360 |
| 1004 | Battlefield: Bad Company | June 26, 2008 | First person shooter | PS3,XBOX360 |
| 1005 | LittleBigPlanet | October 01, 2008 | Puzzle platformer | PS3 |
SELECT *
FROM Games
WHERE ID
BETWEEN 1002 AND 1004
FROM Games
WHERE ID
BETWEEN 1002 AND 1004
Once executed the resultset would look like this:
| ID | Title | Release Date | Genres | Platform |
|---|---|---|---|---|
| 1002 | Gran Turismo 5 | November 24, 2010 | Racing | PS3 |
| 1003 | Assassin’s Creed | November 14, 2007 | Third person | PS3,XBOX360 |
| 1004 | Battlefield: Bad Company | June 26, 2008 | First person shooter | PS3,XBOX360 |
Give it a go and once you feel comfortable using the SQL BETWEEN OPERATOR move on to our next tutorial SQL LIKE OPERATOR.
