If you want to show the data on the basis of a condition, then you use WHERE clause for it. For example, if you want to see a list of only those categories whose category name is apple then it can be done by WHERE clause.

WHERE clause processes all the rows on the basis of a particular condition. This condition applies to every row of the table. The row for which this condition is true can be shown in the result by getting a row fetch. The rows for which these conditions are false are not shown in the result.

WHERE clause is defined in the name of the table. After that the condition is written on which base you want to show results. In this condition, you use operators. An example of this is being given below.

mysql> select name from category where name = apple;

In the above example, WHERE clause is showing the category name of category table, whose name is apple.