The WHERE clause is used to filter records.
It is used to extract only those records that fulfill a specified condition
1-Where syntax in mySql :
select * from Table_name where column_name=condition
2-And Syntax In MySql :
Select * from Tbale_name where column_name=condition and column_name=condition
3-Or Syntax In MySql :
Select * from Tbale_name where column_name=condition or column_name=condition