Remove everything before first # in mysql field

Excuse my ignorance.

I need to replace all data in a mysql field before and including the first # .

example field = golfers

data at the first hole the 开发者_如何学编程golfer missed a 9 inch putt and said "#hit it bad

new data hit it bad

update table set new_column_name = substring(column_name, instr(column_name, '#') + 1);