title: why the table is giving output like this?
body: <p>I was setting a mcq question paper of an online test. So the table for storing the question and options have fields like this :</p>
  
  <pre><code>question_id -PRIMARY KEY ,question_description varchar(1000),option_a -varchar(100),option_b -varchar(100) ,option_c -varchar(100),option_d -varchar(100),answer -(int)
  </code></pre>
  
  <p>The question that I am trying to set is </p>
  
  <pre><code>Q) a and b volumes of solutions of concentration x% and y% respectively  by volume are mixed to form a new solution of resultant concentration z%. If it is known that z is less than the average of x and y, then:
  1) a&gt;b if x&gt;y   2) a&gt;b if x&lt;y  3) a&lt;b if x&gt;=y  4) a&lt;b if x&lt;y 
  </code></pre>
  
  <p>so when I am inserting it into the table the options are not coming in proper way. It is coming like this :</p>
  
  <pre><code>Q) a and b volumes of solutions of concentration x% and y% respectively by volume are mixed to form a new solution of resultant concentration z%. If it is known that z is less than the average of x and y, then:
  
  1) a&gt;b if x&gt;y 2) a&gt;b if x 3) a=y 4) a
  </code></pre>
  
  <p>Why this kind of output is coming? </p>
  
  <p>1)a>b if x>y</p>
  
  <p>2)a>b if x
  3)a=y</p>
  
  <p>4)a</p>
  
  <p>The insert statement was like this :</p>
  
  <pre><code>INSERT INTO table_name(question_description,option_a,option_b,option_c,option_d,answer)
  VALUES('Q) a and b volumes of solutions of concentration x% and y% respectively by volume are mixed to form a new solution of resultant concentration z%. If it is known that z is less than the average of x and y, then:','a&gt;b if x&gt;y   ','a&gt;b if x&lt;y  ','a&lt;b if x&gt;=y  ','a&lt;b if x&lt;y  ','1');
  </code></pre>
  
  <p>and the select statement is like this (this was question number 5) </p>
  
  <pre><code>SELECT * from table_name WHERE  question_id = '5';
  </code></pre>