GNU Info
(mysql.info)Retrieving data
Retrieving Information from a Table -----------------------------------
Selecting all- Selecting all data
- Selecting rows
- Selecting particular rows
- Selecting columns
- Selecting particular columns
- Sorting rows
- Sorting rows
- Date calculations
- Date calculations
- Working with NULL
- Working with `NULL' values
- Pattern matching
- Pattern matching
- Counting rows
- Counting rows
- Multiple tables
- Using More Than one Table
The `SELECT' statement is used to pull information from a table. The
general form of the statement is:
SELECT what_to_select
FROM which_table
WHERE conditions_to_satisfy
`what_to_select' indicates what you want to see. This can be a list of
columns, or `*' to indicate "all columns." `which_table' indicates the
table from which you want to retrieve data. The `WHERE' clause is
optional. If it's present, `conditions_to_satisfy' specifies
conditions that rows must satisfy to qualify for retrieval.
automatically generated by info2www version 1.2.2.9