P piepo Member Jan 2, 2016 #1 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. Thanks
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. Thanks
Paul B XenForo moderator Staff member Jan 2, 2016 #2 Code: UPDATE xf_user_profile SET location = ''; Take a backup first. Upvote 0 Downvote