SQL WHERE statement

The SQL SELECT WHERE statement is used to retrieve data from a database table based on a specific condition. The WHERE clause is used to filter the result set, and only the rows that meet the specified condition are returned.

Syntax for a SELECT WHERE statement

1SELECT column1, column2, ... columnN 
2FROM table_name 
3WHERE condition;

In this syntax, column1, column2, ... columnN are the names of the columns that you want to retrieve, table_name is the name of the table from which you want to retrieve the data, and condition is the condition that the rows must meet in order to be returned.

For example, consider a table named customers that contains the following data:

1+----+-------+--------+
2| id | name  | city   |
3+----+-------+--------+
4| 1  | William  | Boston |
5| 2  | Mike  | Paris  |
6| 3  | Max   | Berlin |
7| 4  | Alice | Paris  |
8+----+-------+--------+

If you want to retrieve only the rows where the city is Paris, you can use the following SELECT WHERE statement:

1SELECT name, city 
2FROM customers 
3WHERE city = 'Paris';

The result set of this statement will be:

1+-------+-------+
2| name  | city  |
3+-------+-------+
4| Mike  | Paris |
5| Alice | Paris |
6+-------+-------+

As you can see, only the rows where the city is Paris are returned.