In MySQL how do I iterate over a BLOB?

Let's say there is a BLOB and I would like to replace every occurrence of a particular byte. So I have to iterate over it, right? How do I do that?

In MySQL how do I iterate over a BLOB?