MySQL Where

MySQL Where

MySQL where syntax and examples.

MySQL Where syntax

SELECT * FROM table_name WHERE condition;

Table books

IDNAMEPRICE
1book120.0
2book225.0
3book315.0

Where example

SELECT * FROM books WHERE id=2;

Query Result

IDNAMEPRICE
2book225.0