Where

SQL WHERE

The WHERE condition is used to return the records that fulfill the conditions immediately after the keyword.

Syntax

SELECT * FROM name_of_table WHERE condition;

Example

Table of books

IDNAMEPRICE
1Learn Python45
2MySQL Tutorial32
3PHP examples24
4Learn SQL32
SELECT * FROM books WHERE price=32;

Output

IDNAMEPRICE
2MySQL Tutorial32
4Learn SQL32