MySQL Where Clause - Php Mysql Create Database - Phptpoint.com

MySQL Where Clause

/ins>

Use Of MySQL Where Clause

The WHERE clause is used to extract only those records that fulfill a specified condition.
where clause is a part of select command . it is used to fetch data from a table . we basically use this clause to filter out our results. by using where clause we can select particular set of records based specified condition.

Syntax

The following example selects all data from the “empInfo” table where email=’devesh@gmail.com’

Output :

Emp_id Name Email Mobile
1 devesh devesh@gmail.com 9910099100

In above example first of all we make connection with the database after that select query is used to search various records and a where clause is given according to which , wherever emp_id matches with devesh@gmail.com all the fields of that particular record are shown in tabular form.