SQL WHERE

WHERE clause is used to make filters in queries, ie, selecting only a few rows of the table that meet a certain condition.

The value of the condition must be enclosed in single quotes ' '

Example SQL WHERE

Select people whose name is HARRY

SELECT * FROM people WHERE name = 'HARRY'
namesurnamenickname
HARRYCLARKWHITE
HARRYSMITHBENITO