MySQL Where

MySQL Where

MySQL where syntax and examples.

MySQL Where syntax

SELECT * FROM table_name WHERE condition;

Table books

ID NAME PRICE
1 book1 20.0
2 book2 25.0
3 book3 15.0

Where example

SELECT * FROM books WHERE id=2;

Query Result

ID NAME PRICE
2 book2 25.0