I'm creating a multiple choice quiz online. I want to store all the potential questions in a MySQL database. Currently I'm thinking of one column being 'Question ID', one column being 'Question', one column being the answers in this form: ['A','B','C'], and the last column being the answer. If I add all four possible options in one column will I eventually be able to extract them and display them as individual questions? What format should I use to do that?
Well your approach is not incorrect if you are thinking to store all the data in one table but it would be best if you create multiple tables for better management and flexibility as
Question Table :- Contains column id and question .
Answer Table :- Contains column id,answers Ques_Ans table : Contains columnid,ques_id,ans_id,is_answer