Todd played for 11 teams during his major league career. It was with the Mets that he reached his only World Series in 2000, a season in which he had 22 home runs in a team-leading 153 games played. Zeile hit a solo homer and a grand slam in a 12-8 Mets victory over the Cardinals at St. Louis on May 27. He hit a game-tying single in the ninth inning of a 10-5 Mets win over the Dodgers on May 30 at Los Angeles. At Chicago on June 14, Todd had a single and a pair of doubles in the Mets' 10-8 win over the Cubs. He hit a game-winning, two-run double for a 10-8 Mets victory over the Pirates at Shea Stadium on June 24. Zeile homered in the Mets' 2-0 win over the Yankees on July 9 at Shea. He had two singles, a triple and a pair of runs scored in a 9-8 Mets victory over the Expos in a doubleheader opener at Shea on July 27. On September 5, Todd hit a home run in the tenth inning to give the Mets a 3-2 win at Cincinnati. He batted .368 with a home run in the National League Championship Series against the Cardinals. In the World Series, Zeile hit .400 against the Yankees.
In 2001, Zeile led the Mets with 151 games played and 105 singles. He had 36 extra-base hits (25 doubles, 1 triple, 10 home runs) and 62 runs batted in during the season. Todd homered, singled twice and drove in three runs in the Mets' 4-0 victory over the Expos on April 17 at Shea. He hit a two-run single that put the Mets ahead to stay in a 5-2 win over the Reds at Cincinnati on April 21. One day leater, Zeile drove in three runs with a pair of doubles in a 5-1 Mets victory over the Reds. He had two singles, a double and two runs scored in an 8-1 Mets win over the Diamondbacks at Shea on May 5. Todd hit a three-run homer in a 4-3 Mets win over the Marlins in 10 innings at Shea on May 25. He drove in all the Mets' runs in the 3-1 Mets' win over the Braves in Atlanta on June 29 with a single and his only triple of the season. Zeile singled twice and drove in a run in a 3-0 Mets victory over the Blue Jays at Shea on July 16. He also had a two-run single in a 5-4 Mets triumph over the Brewers on August 8 at Shea.
After two seasons with other teams, Zeile completed his career with the Mets in 2004. He batted .233 for the season in 137 games played. At San Juan, Puerto Rico on April 9, Todd hit a run-scoring double in the top of the 11th inning for a 3-2 Mets win over the Montreal Expos. He homered and drove in the winning run with a tenth-inning single in a 4-1 Mets victory over the Phillies at Philadelphia on June 1. One day later, Zeile hit a game-tying, three-run homer in the eighth inning and a game-winning, two-run homer in the tenth to give the Mets a 5-3 win over the Phillies. He also hit a three-run homer in his last major league at bat in the Mets' 8-1 win over the Expos on October 3. This homer was the last one ever hit against the Montreal team before its relocation to Washington, D.C.
- Todd's wife is former American gymnast Julianne McNamara. In the 1984 Olympics, Julianne won silver medals in the team competition and the floor exercise. She also tied for the gold medal on the uneven bars.