Is there Types available

[sammy]

I have started my working with select statement. I wanted to know is there any types or clauses in select statement.If so how many types are there and what are they?

[Rahulbatra]

There are various clauses available in select statement of MYSQL. One of the commonly used clause is the WHERE clause.
The general syntax of where clause is

SELECT column_names from table_name [WHERE ...conditions];

In the above syntax the conditions are optional.