how to clean some character from row in mysql?
Fairly easy with a couple of string functions ... change test to the name of your table of course.

update `test` set bfi_name = substr(bfi_name,instr(bfi_name,' ')+1)