Sometimes it's nice to know of a hack to do something really simple, but also very useful. Such is the case with this one-liner that will add any character you want before (or after) the content in your column. For example, here's how to add an asterisk:
UPDATE table SET column = Concat('*', column)
UPDATE table SET column = Concat(column, '*')