John Meyer wrote:
I'm trying to pull up a list of users who haven't tweeted in 7 or more
days, and I'm trying to use this statement:
SELECT USER_NAME, MAX(TWEET_CREATEDAT) FROM USERS NATURAL JOIN TWEETS
WHERE DATEDIFF(NOW(),MAX(TWEET_CREATEDAT)) 7
But it says invalid group function. How
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Wednesday, September 16, 2009 7:34 PM
To: John Meyer; mysql@lists.mysql.com
Subject: RE: Datediff function
Hi John,
You can't use aggregate function in the WHERE clause, because they aren't
evaluated until after the WHERE
Subject: Re: Datediff function
Gavin Towey wrote:
Hi John,
You can't use aggregate function in the WHERE clause, because they aren't
evaluated until after the WHERE clause is applied.
Wouldn't it be much easier to simply keep a last_tweet_date field updated
somewhere then simply do
SELECT
Hi John,
You can't use aggregate function in the WHERE clause, because they aren't
evaluated until after the WHERE clause is applied.
Wouldn't it be much easier to simply keep a last_tweet_date field updated
somewhere then simply do
SELECT USER_NAME FROM USERS WHERE last_tweet_date
Gavin Towey wrote:
Hi John,
You can't use aggregate function in the WHERE clause, because they aren't
evaluated until after the WHERE clause is applied.
Wouldn't it be much easier to simply keep a last_tweet_date field updated
somewhere then simply do
SELECT USER_NAME FROM USERS WHERE
Gabriel Alessandria wrote:
I am a user of Microsoft Sql Server and use very much the function Datediff
(interval, fecha1, fecha2) to extract differences between two dates, in
years, days, months, hours, etc
I am a beginner with MySql and i can't see the way to do this function ..
How can I
Michael Stassen said:
Gabriel Alessandria wrote:
I am a user of Microsoft Sql Server and use very much the function
Datediff (interval, fecha1, fecha2) to extract differences between two
dates, in years, days, months, hours, etc
I am a beginner with MySql and i can't see the way to do this