SQL Tips extract First name and last name from full name
BSTRING_INDEX(full_name, ' ', 1): Returns the substring from the start up to the first space, which is the first name.
SUBSTRING_INDEX(full_name, ' ', -1): Returns the substring from the last space to the end, which is the last name.