Delete special characters from text

from the Artful MySQL Tips List

Given undesirable utf8 character xy in @txt: replace( @txt, unhex('xy'), '' ) Last updated 31 Mar 2016