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

[Scanu]

Did you try this?

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