MySQL Tutorial

MySQL Where Clause

MySQL Where Clause

Most of the time, when you writing mysql queries to fetch data from database table, then you need to use the mysql where clause to get the accurate values what you want.

By using the WHERE clause, you can specify selection criteria to select the data as per your requirement from a database table.

Below is the syntex ot write the where clause in mysql queries:

Example: MySQL Where Clause

Below are some real time examples of mysql where clause:

Example 1

Above query will fetch employee details whos employee id is 214.

Example 2

Above query will fetch all employees details whos employee department is IT.

Example 3

Above query will fetch employee details whos name is “Prem” and the department is “IT”.