title: Mysql: How to query a column whose type is bit?
body: <p>Hi I am using hibernate and Mysql. I have a class with a boolean attribute called 'active'.</p>
  
  <p>The generated database table has the BIT data type. So far so good.
  I want to query this value but I don't know how to do it.
  I've tried </p>
  
  <pre><code> SELECT * from table where active = 1
  </code></pre>
  
  <p>doesn't work, neither the following</p>
  
  <pre><code> SELECT * from table where active = true
  </code></pre>
  
  <p>I didn't find anything neither in the reference manual nor at Stackoveflow.</p>
  
  <p>Any hint?</p>
  
  <p>Thanks in advance!</p>