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

MySQL Where Clause

PHP Summer Training/Internship with 2 Live Projects in Noida Fee is only 5500/-Click here to Book Your Seat.

/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_idNameEmailMobile
1deveshdevesh@gmail.com9910099100

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.

Latest Trending Technologies