1. 

   Brent W Well-Known Member

   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.

    

   Brent W, Jun 11, 2012

   #1
2. 

   Jake Bunce XenForo Moderator Staff Member

   Code:

   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
   );
   

    

   Jake Bunce, Jun 11, 2012

   #2

   aiman.h.kallaf, NSL, Alien and 1 other person like this.

• Log in with Facebook
• Log in with Twitter
• Log in with Google

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in