MySQL Where Clause

In the previous chapter SELECT statement is used to fetch data from MySQL table. Here we can add WHERE clause to filter out results. Using WHERE clause we can specify a selection condition to select only those records which fulfills the specified condition.

Syntax:

A WHERE clause can be used alongwith DELETE or UPDATE SQL command also.