UPDATE users SET fullname = REPLACE(fullname, ' ', '') WHERE fullname ~* ' ';