Moving users into a user group based on signature url and ...

[John Lester]

Ok so I'm trying to move users from the registered user group into another user group if they have a certain url in their signature, have zero posts, and a certain lastvisit time.

This is the query I came up with;

UPDATE user SET usergroupid = 3
WHERE (SELECT userid 
        FROM usertextfield
        WHERE signature LIKE 'google')
AND posts = 0
AND lastvisit = 1342328885

The attached picture is what happens in phpmyadmin.

No users get moved Yes I have one user with the signature of www.google.com with zero posts and a lastvisit of 1341119285. Doesn't do anything different if I replace = with another symbol ( < > <= >= ) in the lastvisit clause.