Find & Replace data in MySQL

I can never remember the above so I’m sharing it here in an effort to help me remember. At worst it’ll be quicker to find next time.