MySQL Tutorial: Managing MySQL data

SQL Select Statement - Searching Data

In our example database this only returned one result, Peggy.

To do this same search from the query window or command line we would type in:

SELECT * FROM people WHERE age < 12

What this does is SELECT *(all columns) from the "people" table WHERE the "age" field is a number less than 12.

If we only wanted to see the names of people who are under 12 years old we could run this instead:

SELECT name FROM people WHERE age < 12

This may be more helpful if your database contains a lot of fields that are irrelevant to what you are currently searching for.

• Insert Into SQL - Add Data
• SQL Update Command - Update Data
• SQL Select Statement - Searching Data
• SQL Delete Statement - Removing Data