1. Home
  2. Computing & Technology
  3. PHP / MySQL

Select - MySQL Command

By Angela Bradley, About.com

Definition: The select statement is used in SQL to specify what data you would like returned when querying the MySQL database. An asterisks [*] will return all data, or you can choose specific data.
Examples:
SELECT * FROM Table_name;
This will return all data from the table called Table_name

SELECT name FROM People WHERE email = "SpaceCowboy@yourname.com";
This will return the data from the "name" field on the table called "people" for the person who's email address is SpaceCowboy@yourname.com
Explore PHP / MySQL
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. PHP / MySQL
  4. MySQL Commands
  5. SQL Select - SQL Select Statement - MySQL Select

©2009 About.com, a part of The New York Times Company.

All rights reserved.