Help with MySQL simple query

Hi folks,
New to MySQL. I just want to be able to run a query to find user who has posted X numbers start from X date.

In example below I can get all users who have posted 2000 posts or more. Can I use a system date to limit only to those who has posted 2000 posts from January 01, 2008. There is no date field on the table. Any suggestions or hints are appreciated.

SELECT *
FROM cms_users
WHERE user_posts >= '2000'

 

if there isn't any date field that's not good - can't make it to filter date if there is no date sorry

 

Hello,

Do you have any other associating table where you can get them filter out on date ?

 

If you mean to order the entries by the time they were added to the MYSQL DB (for example, user posts = DB entry created/updated = MYSQL timestamp placed), then this is not possible, because MYSQL does not write down by default when an entry is created/updated. That's why people usually make another column for the "date posted". Then get the entries and order them by that date column.

 

Thank you all for checking. I saw another table called cms_bbposts which has a field called post_time but I can't make sense of what is in that collum - it is 11 numeric achacraters like 1228821530. Is this something that I can use?

 

that is the date in unix, you have to convert it with the date() function in php.

 

If you have an associated table listing the date then it should be easy.

 

Hi mji2010, can you tell a little more about the conversion and include it as part of the mySQL query?

 

SELECT *
FROM cms_users
WHERE user_posts >= '2000'

sorry its difficult, you have to have date in the data base