title: how to force a filter() to match exact cases (case sensitivity) in sqlalchemy?
body: <p>I am using sqlalchemy with mysql database. When I am using following query on User object : </p>
  
  <pre><code>session.query(User).filter(User.name == 'admin').all()
  </code></pre>
  
  <p>I get all the results which have usename as 'Admin', 'admin', 'ADMIN' (basically all case-insensitive 'admin'). I would like to know how can I force a filter() to filter exact matches (without ignoring cases)?</p>
  
  <p>Update : Actually I just came to know that mysql does not allow case-sensitive columns for varchar() datatype. So the simplest solution would be to force a column to be case-sensitive while declaring in mysql, as : </p>
  
  <pre><code>  `name` VARCHAR(255) BINARY NULL UNIQUE,
  </code></pre>
  
  <p>But I would still love to know how can I force a filter to match the results exactly (not ignoring cases). Is there anyway using some inbuilt (or custom, if possible) sqlalchemy func?</p>