What is the syntax of Select Statement in SQL?

The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set. The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at mysql> prompt as well as in any script like PHP.


Here is generic SQL syntax of SELECT command to fetch data from the MySQL table −

SELECT field1, field2,...fieldN
FROM table_name1, table_name2...
[WHERE Clause]