> sql,query Would it be possible to supply BETWEEN in any order (or rather to allow to do that)? Such as WHERE timestamp BETWEEN 20021001000000 AND 20021031235959
would get the same results with WHERE timestamp BETWEEN 20021031235959 AND 20021001000000 or any other case where BETWEEN can be used.... it really is BETWEEN those values wouldn't that be just a simple greater than check.... --------------------------------------------------------------------- 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