Never mind; thanks for the pointers to TFM... =)
The updated, working query looks like this:
TO_DAYS(NOW()) - TO_DAYS(customers.last_mod) > 14
Thanks all!
On Thu, 12 Apr 2001, Chris Harshman wrote:
> At the first of the month (no changes made to the database; this script is
> just running SELECT statements at present) the number of rows returned by
> this query dropped noticeably. Is this a bug, is my query just fubar'd,
> or...?
>
> SELECT account.username AS account_username, customers.username AS
> customers_username, account.accout_no, account.email, customers.last_mod
> FROM account LEFT JOIN customers ON account.username = customers.username
> WHERE (customers.username IS NULL OR customers.username LIKE
> \"%_expired\") OR (customers.last_mod <= current_date() - 14 AND
> customers.access_status = 'D') ORDER BY last_mod";
>
> The number of rows returned:
> 4/10 253
> 4/9 247
> 4/8 243
> 4/7 241
> 4/6 234
> 4/5 226
> 4/4 221
> 4/3 216
> 4/2 207
> 4/1 197
> 3/31 333
> 3/30 312
>
>
> Thanks!
>
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
