SELECT column with WHERE Clause in mysql

We need to filter the return data and we need to use the WHERE clause. WHERE clause uses to filter data according to the criteria.

>>SELECT * FROM profile;

>>SELECT * FROM profile WHERE id=2;

>>SELECT * FROM profile WHERE

>>first_name='Mamun' AND last_name='goodgood';

Display

WHERE clause operator

Operator	Description
=	Equal
!=	Not Equal
<>	Not Equal
<	Less than
>	Greater than
>=	Greater than or equal to
<=	Less than or equal to
BETWEEN	Between tow specified values