MySQL Where Clause - Php Mysql Create Database -

MySQL Where Clause

PHP 6 Months 100% Job Assistance Program. for more info... call on 8588829328

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.


The following example selects all data from the “empInfo” table where email=’’

Output :

Emp_id Name Email Mobile
1 devesh 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 all the fields of that particular record are shown in tabular form.

Latest Trending Technologies