I'm trying to write a MySQL query which does the following:
Checks to see that each userid in usergroupid 14 has five (or more) new entries in the post table within the last week. If not, changes their usergroupid to 2, and their usertitle to "member."
I'm working with two tables:
userid, usergroupid, usertitle
MySQL version - 4.0.22-standard
Can anyone please tell me how to do this correctly?