SQLite Help: WHERE
 

Is there any way you can make a WHERE statement have more than 1 expression, that way I don't have to have a loop to make sure all the columns match with what I want, but can do it in 1 step.
Similar to && in an if () statement.

You'll find that SQL is often exactly how you think it.

NPC Code:

---

SELECT whatever

FROM table

WHERE rawr=1

AND meow=2

---

Here's a good resource to check out for SQL.

http://w3schools.com/sql/default.asp

Thanks :)
I was reading from http://www.sqlite.org/lang_select.html and http://www.sqlite.org/lang_update.html which didn't have AND anywhere.
But I guess I didn't read far enough in http://www.sqlite.org/lang_expr.html :p