Specifies the search condition for the rows returned by the query.
The following examples show how to use some common search conditions in the WHERE clause.
A. Finding a row by using a simple equality
USE AdventureWorks2012 GO SELECT ProductID, Name FROM Production.Product WHERE Name = 'Blade' ; GO
B. Finding rows that contain a value as a part of a string
C. Finding rows by using a comparison operator
D. Finding rows that meet any of three conditions
SELECT ProductID, Name FROM Production.Product WHERE ProductID = 2 OR ProductID = 4 OR Name = 'Spokes' ; GO
E. Finding rows that must meet several conditions
SELECT ProductID, Name, Color FROM Production.Product WHERE Name LIKE ('%Frame%') AND Name LIKE ('HL%') AND Color = 'Red' ; GO
F. Finding rows that are in a list of values
SELECT ProductID, Name, Color FROM Production.Product WHERE Name IN ('Blade', 'Crown Race', 'Spokes'); GO
G. Finding rows that have a value between two values