A tábla illesztés: utf8_general_ci
mysql_query("SET NAMES 'utf8';");
mysql_query("SET CHARACTER SET 'utf8';");
mysql_query("SET SESSION collation_connection = 'utf8_general_ci';");
És ez lenne az a lekérdezés:
SELECT origdate,hometeam,awayteam,result,matchtime FROM football GROUP BY hometeam ORDER BY origdate DESC