MySQL help!!

[kalvin]

I am creating an exam bank which runs on MySQL. I would like to know if there is any way restrict my database from repeating the same question twice within 6 months. Do you I have to use AI? pls let me know..thank you!

[jp140768]

This may be oversimplistic, but could you not add a new field called lastasked date, set this when the question is selected. Your select statement could then select questions which are only 6+ months old.

HTH