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.

Index: MySQL Tutorial: Managing MySQL data

1. Insert Into SQL - Add Data
2. SQL Update Command - Update Data
3. SQL Select Statement - Searching Data
4. SQL Delete Statement - Removing Data