He played college football for the LSU Tigers of Louisiana State University, where he holds several school passing records.
Hodson was selected by the New England Patriots in the third round of the 1990 NFL draft.
In the NFL, he served primarily as a backup quarterback, playing for four different teams in six seasons, though he did start a number of games for the Patriots in the early 1990s.
He played quarterback at Central Lafourche High School, where he passed for 4,361 yards and 36 touchdowns.
Hodson passed for over 2,000 yards during each of his four seasons at LSU, becoming the third player in NCAA history to achieve that feat.
Hodson was selected first team All-SEC during each of his four seasons at LSU, the only player in school history to achieve that feat.
During Hodson's freshman season (1986), he led LSU to its first AP Top 10 finish since 1970 and its first SEC Championship since 1970.
During Hodson's sophomore season (1987), he led LSU to its first AP Top 5 finish since 1961.
†Led SEC Hodson was selected 59th overall in the 1990 NFL draft by the New England Patriots.
The Globe reported that Hodson lives in Baton Rouge with his wife and his 10-year-old identical twin daughters, and quoted Hodson as saying that he lives in Baton Rouge because he has "fond memories" at LSU and because it is "a good place to raise a family.