how to clean some character from row in mysql? How to remove some part of rows from column in mysql? I have a column like this



my desire output is like this
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)