SQL SELECT and WHERE Explained for Beginners

If you searched for "SQL SELECT and WHERE explained for beginners", here is the short answer: SELECT tells the database which columns of data you want to see, and WHERE tells it which rows to include by filtering out the ones you don't need. Together, SELECT and WHERE are the two most important building blocks of SQL, the language used to talk to databases. By the end of this guide, you will be able to write real queries yourself, even if you have never touched a database before.

What is SQL?

SQL stands for Structured Query Language. It is how you ask a database questions, like "show me all customers from Canada" or "find every order placed last week". A database stores information in tables, which look a lot like spreadsheets: rows and columns. SQL is the language you use to read, add, change, and delete that information.

If you already connected a PHP application to a MySQL database, SQL is the language you'll use inside that connection to actually fetch data. This guide focuses purely on reading data with SELECT and WHERE, which works the same way in MySQL, PostgreSQL, SQLite, and almost every other SQL database.

A sample table to practice with

To keep things concrete, imagine a table named customers that stores information about people who signed up for a service. Every example below uses this table.

The SELECT statement

SELECT is how you choose which columns to see. The most basic query selects every column from a table using the * symbol, which means "all columns".

SELECT *
FROM customers;

Line by line: SELECT * means "give me every column". FROM customers means "look in the customers table". The semicolon (;) at the end tells the database this statement is finished. This query returns all four rows and all four columns from the table above.

Usually you don't need every column. You can list only the ones you want, separated by commas. This is faster and easier to read.

SELECT name, country
FROM customers;

This query returns just two columns, name and country, for every row in the table. The order you list the columns is the order they appear in the results.

Filtering rows with WHERE

SELECT decides which columns you see. WHERE decides which rows you see. You add a WHERE clause after FROM to filter the results using a condition.

SELECT name, country
FROM customers
WHERE country = 'Canada';

Line by line: SELECT name, country picks the two columns to show. FROM customers picks the table. WHERE country = 'Canada' keeps only the rows where the country column exactly equals the text Canada. Text values in SQL go inside single quotes. This query returns just Liam Chen, since he is the only customer from Canada.

WHERE works with numbers too, and you can use comparison operators like greater than (>) or less than (<).

SELECT name, signup_year
FROM customers
WHERE signup_year > 2023;

This keeps only customers who signed up after 2023, meaning signup_year is 2024. Notice that numbers, unlike text, don't need quotes around them.

Combining conditions with AND and OR

You can check more than one condition at once. AND keeps a row only if all conditions are true. OR keeps a row if at least one condition is true.

SELECT name, country, signup_year
FROM customers
WHERE country = 'Nigeria' AND signup_year = 2024;

This returns only rows where both conditions are true at the same time: the country must be Nigeria, and the signup_year must be 2024. Amara Okafor matches both, so she is the only row returned.

Common WHERE operators

Here are the operators you will use most often when filtering with WHERE.

The % symbol in LIKE means "any characters can go here". So name LIKE 'S%' matches any name starting with the letter S, such as Sofia.

Sorting results with ORDER BY

SELECT and WHERE control what you see. ORDER BY controls the order results appear in. Add it at the end of your query.

SELECT name, signup_year
FROM customers
WHERE signup_year >= 2023
ORDER BY signup_year DESC;

DESC means descending, so the newest signups appear first. Use ASC for ascending order (oldest or smallest first), which is also the default if you leave DESC or ASC out.

Try it yourself

You don't need to install anything to practice. Most database tools, including phpMyAdmin, pgAdmin, or free online SQL sandboxes, let you type a query and run it instantly. Try these three exercises using the customers table above.

1. Write a query that selects only the name column for every customer.
2. Write a query that selects name and country, but only for customers who signed up in 2024.
3. Write a query that selects everything, ordered by signup_year from newest to oldest.

Mistakes beginners often make

• Forgetting quotes around text values, like writing WHERE country = Canada instead of WHERE country = 'Canada'.
• Using a single = sign correctly is fine in SQL (unlike some programming languages that need ==), but forgetting it entirely causes an error.
• Putting WHERE before FROM. The correct order is always SELECT, then FROM, then WHERE.
• Forgetting the semicolon at the end of a statement when running multiple queries together.
• Assuming SELECT * is always fine in real applications. It works for learning, but naming columns explicitly is faster and safer once you build real projects.