> Shouldn't the first query have parenthesis? As in:
> DELETE FROM test WHERE userID=XXXXX AND (testID<200000 OR
> testID>800000);
> Even if it works the other way, parenthesis make it more clear what
> you're trying to accomplish.
> -Angela
Actually, yes. Sorry about the poor example. My point is that sometimes
applications can be sped up by splitting OR queries into two separate
queries, and I believe many times the server could recognize this, although
I am wrong in this particular example. I'll have to check my code for an
exact situation.
Michael
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php