Check website fields

update locations set website = replace(website, 'm.facebook', 'facebook') where website ilike '%m.facebook%';

Checks for any empty spaces in website fields. Manually correct after. select name from locations where website like '% %';