In this tutorial you will learn about the MySQL Where Clause and its application with practical example.
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.
Table Of Contents−
Syntax:
|
1 2 |
SELECT field1, field2,...fieldN FROM table_name1, table_name2... [WHERE condition1 [AND [OR]] condition2..... |
A WHERE clause can be used alongwith DELETE or UPDATE SQL command also.
