Open emeraldjava opened 9 years ago
It seems Senior is getting inserted instread of S for the runners age category.
SELECT DISTINCT(category) FROM wp_bhaa_raceresult; UPDATE wp_bhaa_raceresult SET category = 'S' WHERE category = 'Senior'; UPDATE wp_bhaa_raceresult SET category = 'S' WHERE category IS NULL;
It seems Senior is getting inserted instread of S for the runners age category.