SQL AND Operator

The SQL AND OPERATOR is used when you need both the first condition and second condition in your query to be matched.

SQL AND OPERATOR Syntax

SELECT “column_name(s)”
FROM “table_name”
WHERE “condition1″ AND “condition2″

Now you know the syntax let me show you some examples.

SQL AND 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=1005 AND Platform=’PS3′

Once executed the resultset would look like this:

ID Title Release Date Genres Platform
1005 LittleBigPlanet October 01, 2008 Puzzle platformer PS3

Give it a go and once you feel comfortable using the SQL AND OPERATOR move on to our next tutorial SQL OR OPERATOR.