WHERE clause could be used with AND, OR and NOT operators. AND and OR operators are used to filter records based on more than one condition.
<?php
SELECT DISTINCT column1, column2....columnN
FROM table_name
WHERE condition1 AND condition2....columnN;
?>
<?php
SELECT * FROM Customers
WHERE Country='pakistan' AND City='sargodha';
?>
<?php
SELECT DISTINCT column1, column2....columnN
FROM table_name
WHERE condition1 OR condition2...;
?>
<?php
SELECT * FROM Customers
WHERE Country='pakistan' AND City='sargodha';
?>
<?php
SELECT DISTINCT column1, column2....columnN
FROM table_name
WHERE NOT condition;
?>
<?php
SELECT * FROM Customers
WHERE NOT Country='USA';
?>