SQL OR Operator
The SQL OR OPERATOR is used when you need either the first condition or second condition in your query to be matched.
SQL OR OPERATOR Syntax
SELECT “column_name(s)”
FROM “table_name”
WHERE “condition1″ OR “condition2″
FROM “table_name”
WHERE “condition1″ OR “condition2″
Now you know the syntax let me show you an example.
SQL OR 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=1004 OR Title=’Gran Turismo 5′
FROM Games
WHERE ID=1004 OR Title=’Gran Turismo 5′
Once executed the resultset would look like this:
| ID | Title | Release Date | Genres | Platform |
|---|---|---|---|---|
| 1002 | Gran Turismo 5 | November 24, 2010 | Racing | PS3 |
| 1004 | Battlefield: Bad Company | June 26, 2008 | First person shooter | PS3,XBOX360 |
Give it a go and once you feel comfortable using the SQL OR OPERATOR move on to our next tutorial SQL NOT OPERATOR.
