title: SQL Bitwise operation (MySql)
body: <p>So in my table i have id and bitwise columns like so</p>
  
  <pre><code>+----+---------+
  | id | bitwise |
  +----+---------+
  | 1  | 1       |
  | 2  | 6       |
  | 4  | 60      |
  +----+---------+
  </code></pre>
  
  <p>From my c# code i'm setting these names to these binary values</p>
  
  <pre><code>Name1 = 0x0001,
  Name2 = 0x0002,
  Name3 = 0x0004,
  Name4 = 0x0008,
  Name5 = 0x0010,
  Name6 = 0x0020,
  Name7 = 0x0040,
  Name8 = 0x0080,
  Name9 = 0x0100,
  Name10 = 0x0200,
  Name11 = 0x0400,
  Name12 = 0x0800
  </code></pre>
  
  <p><strong>I would like to know the best way to extract the specific record for example lets use id=2
  and its representing value</strong></p>
  
  <p><code>id=2</code> should yield <code>Name2, Name3</code></p>
  
  <p>At the moment I'm not sure how I can <code>select</code> a bit from the table into the values without a Huge <code>If</code> <code>Else</code> and <code>case</code> <code>when</code> Statement.</p>
  
  <p>I'm not asking for you to solve this (unless you want to) I just need to know the next steps
  like how to create a list and or if this list needs to reside in a table format</p>