SQL Tutorial: WHERE

The SQL WHERE clause is used to specify a condition. You can use the WHERE clause in the query to select, delete, update the record

Syntax

SELECT column1, column2, ...
FROM table_name
WHERE [condition]
UPDATE table_name
SET column1 = value1, column2 = value2....
WHERE [condition]
DELETE FROM table_name
WHERE [condition]

Related Posts