1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 Mass Empty 'Location' field on DB - Query?

Discussion in 'XenForo Questions and Support' started by piepo, Jan 2, 2016.

  1. piepo

    piepo Member

    Hey guys,

    I need to empty all information within the location field of all user profiles.

    I still wanna make use of it. That's why I don't want to delete it completly.

    Can someone provide the SQL command for me?

    I can't get it right now.

  2. Brogan

    Brogan XenForo Moderator Staff Member

    UPDATE xf_user_profile SET location = '';
    Take a backup first.
    piepo likes this.
  3. piepo

    piepo Member

Share This Page