mysql 存储多字符字段,在MySQL数据库表中存储多个字符串

Before I ask my question, I just wanted to thank everyone that replied to my question yesterday -> Countdown using javascript.

Idea:

I created a quiz using php, but I would like to create a MySQL Database and having a table with all the questions, answers and multiple choice stored inside.

Issue:

Since the quiz is multiple choice, I don't know how to go about storing the multiple choice options in the table. Could I store the options and have each answer separated by a special character and let php get the string and separate the options?

Ex: Question: What is your favorite color? Options: Blue=Red=Purple=Yellow.(Database View)

What do you folks think is the best practice for something like this?

解决方案

I think the best practice would be to use multiple tables. One for the question and one for answers. The answer table would contain question_id as well as a flag whether or not it is the correct answer

It could look like this

TABLE questions

FIELDS: id, text

TABLE answers

FIELDS: id, question_id, text, correct

The problem with using one field for all the answers is that you could accidently use the character you use for splitting inside the text of an answer