We'll often need multiple steps to 'filtering' our data and results down. We can use multiple "WHERE" statements by using the "AND" statement.

SELECT * FROM Users WHERE age > 25 AND name="Jackie";

We can add as many "AND" statements as we need. Simply continue the pattern:

WHERE column = value
AND column2 = value2
AND column3  = value3
AND ...

For example:

SELECT * FROM Users
WHERE age > 25
AND emailVerified = true
AND country = "INDIA";

0 Comments

Top comments

"Please login to view comments"

Join the Conversation!

Subscribing gives you access to the comments so you can share your ideas, ask questions, and connect with others.

Upgrade your account