Examples Operators Allowed in the WHERE Clause :
Example 1 : Filtering records having unit price equal to $20.00
SELECT ProductID, ProductName, UnitPrice
FROM products
WHERE unitprice = 20.00
Output
ProductID ProductName UnitPrice
49 Maxilaku 20.00
Example 2 : Filtering records of unit price not equal to $20.00
SELECT ProductID, ProductName, UnitPrice
FROM products
WHERE unitprice <> 20.00
Output
ProductID ProductName UnitPrice
1 Chai 18.00
2 Chang 19.00
3 Aniseed Syrup 10.00
Example 3 : Updating records having unit price greater than $20.00 and less than $25.00
UPDATE products
SET discontinued = 1
WHERE unitprice > 20.00
AND unitprice < 25.00
Example 4 : Deleting records having unit price "grater than and equal" to $25.90
and "less than and equal" to $26.00
DELETE FROM products
WHERE unitprice >= 25.90
AND unitprice <= 26.00
Example 5 : Filtering records of unit price between $18 to $20
SELECT ProductID, ProductName, UnitPrice
FROM products
WHERE unitprice BETWEEN 18 AND 20
Output
ProductID ProductName UnitPrice
1 Chai 18.00
2 Chang 19.00
35 Steeleye Stout 18.00
36 Inlagd Sill 19.00
39 Chartreuse verte 18.00
40 Boston Crab Meat 18.40
44 Gula Malacca 19.45
49 Maxilaku 20.00
57 Ravioli Angelo 19.50