[Ben E Lou]

Oh, and I've fixed the names.

update player set player_name=TRIM(player_name)

then

update player set player_name = replace(player_name,' ',' ');