MySQL Where Clause

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

SELECT column_name(s) FROM table_name WHERE column_name = value

The following example selects all data from the "empInfo" table where email='[email protected]'

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 [email protected] all the fields of that particular record are shown in tabular form.