SELECT is used to retrieve rows selected from one or more tables.
Support for UNION statements and subqueries is available as of MySQL
4.0 and 4.1, respectively.
See [UNION,  , UNION] and [Subqueries].

 --- Each select_expr indicates a column you want to retrieve.

 --- table_references indicates the table or tables from which to retrieve rows.
Its syntax is described in [JOIN,  , JOIN].

 --- where_definition consists of the keyword WHERE followed by
an expression that indicates the condition or conditions that rows
must satisfy to be selected.


SELECT can also be used to retrieve rows computed without reference to
any table.
