Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: are double ANDs legal

    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

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There may be some limit, but it is way more than four!

    -PatP

  3. #3
    Join Date
    May 2004
    Posts
    2
    thank you very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •