MySQL Tutorial – Using the WHERE clause

MySQL Tutorial – Using the WHERE clause to filter records

The WHERE clause is used to filter the data to be displayed using the SQL commands such as SELECT, UPDATE, DELETE statement.

The WHERE clause syntax:

SELECT column_name(s) 
FROM table_name 
WHERE column_name operator value;

The following operators can be used together with the WHERE clause:


Here is our database table: (employee_record)


Example: We will retrieve the first name and last name of employee with the position of “Programmer”. Issue the following command:

SELECT f_name,l_name
FROM employee_record
WHERE position=”Programmer”;


| f_name | l_name  |
| Piolo  | Pascual |
| John   | Prats   |
2 rows in set (0.09 sec)
, , ,

Post navigation

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.