MySQL Where statement

MySQL Where Statement :

We can select a particular row using the WHERE clause statement. We can also check any condition using WHERE clause or keyword. Where condition comes handy when we come across a big table having huge volume of data but we might want to see only small number of rows satisfying a condition.
Select Using Where in MySQL syntax is

Syntax :

Here the conditions_to_satisfy specifies one or more conditions that rows must satisfy to qualify for retrieval.

Example :

Let's see an example query for retrieving a single student data using the MySQL WHERE clause.

Here in the above example query we have retrieved a single student details. Suppose if we want to retrieve the student's details who have secured more than 90 marks, we can use the below query.
We have used the mysql where statement to select the particular data from table.