Introduction « Select Query « MySQL Tutorial

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