title: MySQL SELECT email where field contains a value
body: <p>I would like to do a simple select - but the condition is a bit tricky for me (because I'm a SQL-beginner).</p>
  
  <p>I got this table:</p>
  
  <pre><code>userid | email             | newsletters
       1 | test@example.com  | 1,2
       2 | test2@example.com | 1
  </code></pre>
  
  <p>Now I would like to get all email-addresses of users, which want to get newsletter "2".</p>
  
  <p>This would be:</p>
  
  <pre><code>email | newsletters
  test@example.com | 1,2
  </code></pre>
  
  <p>And of course: In another query all users, which are subscribing newsletter number 1:</p>
  
  <p>Result:</p>
  
  <pre><code>email | newsletters
  test@example.com | 1,2
  test2@example.com | 1
  </code></pre>
  
  <p>What would be the correct sql-query?
  I think this should be the right beginning, but I don't know which condition I have to use:</p>
  
  <pre><code>SELECT email FROM users WHERE newsletter CONDITION?
  </code></pre>
  
  <p>Could you please help me out? :-)</p>