[AA_]

Originally Posted by jack the lad

Is there a way of resetting everyone's score?

I would like to do this for the World Cup so we all start with the same amount of points.

Cheers

remove all bets/points on world cup 2010:

DELETE FROM soccer_user_bet
WHERE match_id IN(SELECT id
  FROM soccer_match
  WHERE league_id=(SELECT id FROM soccer_league WHERE sd_id=56)
);

remove all bets/points: (!)

TRUNCATE TABLE soccer_user_bet;