Darn, I wanted to copy the list too when I replied to Jim.... here goes: > > It's non-standard, but I've always been partial to the syntactic sugar: > > <expression> [ not ] between <expression> and <expression> > > In other words, "a not between 1 and 3" is nicer than "not a between 1 and > 3".
Hah! I thought that was non standard too...until Roy corrected me. I looked it up: ISO/IEC 9075-2:2003 (E) 8.3 <between predicate> <between predicate> ::= <row value predicand> <between predicate part 2> <between predicate part 2> ::= [ NOT ] BETWEEN [ ASYMMETRIC | SYMMETRIC ] <row value predicand> AND <row value predicand> So. Now what does MySQL say: mysql> select 1 not between 2 and 3; +-----------------------+ | 1 not between 2 and 3 | +-----------------------+ | 1 | +-----------------------+ all clear ;) _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
