MySQL Where statement
How to use MySQL Where Clause in Select Query?
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
SELECT what_to_select FROM tbl_name WHERE conditions_to_satisfy;
Here the conditions_to_satisfy specifies one or more conditions that rows must satisfy to qualify for retrieval.
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.