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)