EQUALS(=) Constraint



Syntax:

SELECT Column(s)
FROM TableName
WHERE Column = Value;



What does it do?
The Equals Where clause constraint restricts the rows selected to only rows where the value in the column that is used in the equals expression matches.


Example:

SELECT FirstName, LastName
FROM Customers
WHERE FirstName = 'John';


Results:

FirstName LastName
John Black
HTML 5 Badge