TL;DR – The SQL SELECT command is commonly used for search queries. Using it, you can select specific data from your SQL databases. The data you select is stored in a table called a result-set.
Contents
Syntax of SQL SELECT
Selecting specific columns
Example
SELECT column1, column2, ...
FROM table_name;Selecting all columns
Example
SELECT * FROM table_name;Examples using a demo database
The Users table
| ID | Username | Password | |
|---|---|---|---|
| 1 | alfredfutter | alfredfutter@gmail.com | secret1 |
| 2 | atrujillo | atrujillo@gmail.com | secret2 |
| 3 | moreno.antonio | moreno.antonio@yahoo.com | secret3 |
| 4 | hardythomas | thomas.hardy@gmail.com | secret4 |
| 5 | bergluns | bergluns@gmail.com | secret5 |
Using SELECT to retrieve data of specific columns
Using SELECT to retrieve data of all columns
Note: SELECT * selects all columns, SELECT ALL selects all rows.