How to remove some part of rows from column in mysql? I have a column like this
my desire output is like this
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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)