The SELECT statement is used to pull information from a table : Introduction « Select Query « MySQL Tutorial






  1. MySQL Tutorial
  2. Select Query
  3. Introduction

The general form of the statement is:

SELECT what_to_select
FROM which_table
WHERE conditions_to_satisfy;

what_to_select is what you want to see.

what_to_select can be a list of columns

* to indicate "all columns."

which_table is the table name list.

The WHERE clause is optional.

If where clause is present, conditions_to_satisfy specifies conditions that rows must satisfy.









2.1.Introduction
2.1.1.The SELECT statement is used to pull information from a table
2.1.2.The basic SELECT statement syntax
2.1.3.Conditions can be combined to achieve better filtering of results
2.1.4.Hierarchy of Conditions
2.1.5.You can combine conditions
2.1.6.Selecting Particular Columns
2.1.7.To sort a result, use an ORDER BY clause
2.1.8.Use String function in select statement
2.1.9.Three-Table Join
2.1.10.Join a many-to-many map table