Hi to all,

Not that familiar with MySQL so is the following statement a legal command

SELECT * FROM users WHERE activated > "0" AND level = "1"' AND anotherlevel = "2"

so can several or up 4 AND statements be added?

If not how would one perform this type of search
Thanks

There may be some limit, but it is way more than four!

-PatP

thank you very much