faribaa
User
Sep 10, 2009, 5:03 PM
Post #1 of 2
(1828 views)
Shortcut
|
|
seeking a sql statement to query article table date field
|
Can't Post
|
|
I'm trying to query articles posted for the past 30 days. I'm using the following but it returns the entire table, as if I have specified nothing.
select * from am_article where date >= DATE_SUB(curdate(),INTERVAL 30 day)
Any suggestions?
I know that I can use the search.pl to do this but this is a part of a more extensive query.
Thank you
|
