XF 1.1 SQL Query

[Brent W]

Need an SQL query for the following:

Set homepage field to empty for everyone with 0 posts.
Set signature to empty for everyone with 0 posts.

 

[Jake Bunce]

UPDATE xf_user_profile AS up
SET up.signature = '', up.homepage = ''
WHERE 0 = (
	SELECT u.message_count
	FROM xf_user AS u
	WHERE u.user_id = up.user_id
);