MySql WHERE is a command seen as a clause used to sometimes complete other mysql command statements.
SELECT * FROM paymentmethod WHERE paypal = 'Yes';
3 mysql query command statements that uses WHERE clause:
The above listed statements constantly uses WHERE clause to identify the specifications of records query command statements is to be executed on.
How the WHERE clause works
WHERE is use to specifies condition on which the group of records or a record which are been given query to execute .
see the example above as we use
where in MySql Select statement
SELECT column1, column2, ... FROM table_name WHERE condition;
from our example you will notice that when executed the only record that will be selected from the database table (paymentmethod) are the columns (paypal) which it record contains yes.