Do not combine multiple values into a single column; they will be hard to split apart. Instead have multiple columns or (usually better) have multiple rows, perhaps in a separate table.

I suspect this might be best: A table with these columns:

league_id, time, home_id, away_id, ht, ft, type, seq, open, closed

Notes:

• type might be `ENUM('crown', 'bet365', ...)
• seq is 1,2,3 -- for those 3 columns. (What is the significance of them?)
• I don't know what to advise on the "3-0", "1-0" column
• Formatting is the job of the application, not SQL.
• For the above snippet, there would be 24 rows in the table.

how many years did Todd play for Kamalfechuk FC?

your model shows only a player's current team assignment

http://www.seanlahman.com/baseball-archive/statistics/