title: Query needed to get an column values of one table which are not there in string column of another table
body: <p>I have a two tables :</p>
  
  <pre><code>mysql&gt; select * from quizquestionbank;
  
  
  | ID | QuestionFilePath | CorrectAnswer |
  
  
  |  1 | p.wav            |             1 |
  
  |  2 | q.wav            |             2 |
  
  |  3 | a.wav            |             3 |
  
  |  4 | b.wav            |             1 |
  
  |  5 | m.wav            |             3 |
  </code></pre>
  
  <p>Second table is :</p>
  
  <pre><code>mysql&gt; select * from quizuserdetails;
  
  | ID | MSISDN | QuestionIdDetails | AnswerRecord |
  
  |  1 | 235346 | 1,3,4,5           | S,F,S,F      |
  
  |  2 | 564574 | 4,5,67,88         | F,S,F,s      |
  
  |  3 | 500574 | 5,55,66,44,2      | F,F,F,F      |
  </code></pre>
  
  <p>I want to get the IDs from table 1 which are not there in QuestionIdDetails column of second table.</p>
  
  <p>I tried query 
  <code>Select ID from quizquestionbank where ID not in (Select QuestionIdDetails  from quizuserdetails where msisdn = '235346 ');</code></p>
  
  <p>But this does not work 
  CAn anybody suggest a way to do it</p>