I have a game. In the game, people make many choices out of 2 options.
The choice can be either right or wrong and I am storing the result of their run through the game (which can be a very large length) as a string with 1 for a right answer and 0 for wrong answers.
So for example, player 128937
will have stored in his run column the string 00010101010010001010111
as a varchar(5000)
.
Is there a better way I can store this information in MYSQL? (I am using PHP too if that can help)