MySQL WHERE Clause

file

SELECT * FROM Products
WHERE Price <> 18;

SELECT * FROM Products
WHERE Price BETWEEN 50 AND 60;

SELECT * FROM Customers
WHERE City LIKE 's%';

SELECT * FROM Customers
WHERE City IN ('Paris','London');
Posted in Mysql     

Leave a Reply

Your email address will not be published. Required fields are marked *