Structured Query Language (SQL) Tutorials

AND / OR / NOT

1. AND:
SELECT * FROM People WHERE LName='Smothers' AND Category=2

The SQL Statement above will retrieve

ALL fields: SELECT *

From the table named People: FROM People

With the requirement that the LName is Smothers and the category=2: WHERE LName='Smothers' AND Category=2

If this is the original table

People
FName	LName	Category
John	Smith	1
Al	Jones	2
Fred	Smothers	2
Jim	Smothers	1

Your recordset returned would be this:

People
FName	LName	Category
Fred	Smothers	2

2. OR:
SELECT * FROM People WHERE LName='Smothers' OR Category=2

The SQL Statement above will retrieve

ALL fields: SELECT *

From the table named People: FROM People

With the requirement that the LName is Smothers or the category is 2: WHERE LName='Smothers' OR Category=2

If this is the original table

People
FName	LName	Category
John	Smith	1
Al	Jones	2
Fred	Smothers	2
Jim	Smothers	1

Your recordset returned would be this:

People
FName	LName	Category
Fred	Smothers	2
Jim	Smothers	1
Al	Jones	2

3. NOT:
SELECT * FROM People WHERE LName NOT LIKE 'SM%'

The SQL Statement above will retrieve

ALL fields: SELECT *

From the table named People: FROM People

With the requirement that the LName does not start with Sm: WHERE LName NOT LIKE 'Sm%'

If this is the original table

People
FName	LName	Category
John	Smith	1
Al	Jones	2
Fred	Smothers	2
Jim	Smothers	1

Your recordset returned would be this:

People
FName	LName	Category
Al	Jones	2

Come learn HTML or Classic ASP in Honolulu, Hawaii!