how we can use where keyword in our mysql programme

Using WHERE in Your Queries

You’ve used the equal sign (=) in your WHERE clauses to determine the truth of a condition—
that is, whether one thing is equal to another. You can use many types of
operators, with comparison operators and logical operators being the most popular
Basic Comparison Operators and Their Meanings
Operator Meaning
= Equal to
!= Not equal to
<= Less than or equal to
< Less than
>= Greater than or equal to
> Greater than