MySQL SELECT
Introduction
SELECT is used to retrieve rows selected from one or more tables.
Syntax
-
SELECT DISTINCT [expressions] FROM TableName [WHERE conditions]; ///Simple Select
-
SELECT DISTINCT(a), b ... is the same as SELECT DISTINCT a, b ...
-
SELECT [ ALL | DISTINCT | DISTINCTROW ] [ HIGH_PRIORITY ] [ STRAIGHT_JOIN ] [ SQL_SMALL_RESULT | SQL_BIG_RESULT ] [ SQL_BUFFER_RESULT ] [ SQL_CACHE | SQL_NO_CACHE ] [ SQL_CALC_FOUND_ROWS ] expressions FROM tables [WHERE conditions] [GROUP BY expressions] [HAVING condition] [ORDER BY expression [ ASC | DESC ]] [LIMIT [offset_value] number_rows | LIMIT number_rows OFFSET offset_value] [PROCEDURE procedure_name] [INTO [ OUTFILE 'file_name' options | DUMPFILE 'file_name' | @variable1, @variable2, ... @variable_n] [FOR UPDATE | LOCK IN SHARE MODE]; ///Full Select Syntax
Remarks
For more information on MySQL's SELECT statement, refer MySQL Docs.
