Mysql WHERE Clause

You can use one or more tables separated by comma to include various conditions using a WHERE clause, 
but WHERE clause is an optional part of SELECT command.You can specify any condition using WHERE clause

Syntax:

SELECT Column1,Column2,...ColumnN table_name1, table_name2...
[WHERE condition1 [AND [OR]] condition2.....

Examples 1:

Select * from Country where (CountryName='India' Or Code=2) and iscanceled=0