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

[piepo]

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]

UPDATE xf_user_profile SET location = '';

Take a backup first.

 

[piepo]

Thank you @Brogan