title: Anorm & MySQL SHA1 password encrytion is not same with Mysql Workbench command
body: <p>In my Play Framework Scala project I am using MySQL as database. In my database I have a column with the name <code>PASSWORD</code>. I will store the users passwords in this column when they create a new user in my project. I use <code>SHA1</code> encryption for password field while inserting a user vales. If I run the command directly in my database from MySQL Workbench, it will store the different encrypted string in my <code>PASSWORD</code> column.</p>
  
  <p><strong>Command run in MySql Workbench</strong></p>
  
  <pre><code>INSERT into user('PASSWORD') VALUES(SHA1('hello'));
  </code></pre>
  
  <p>this SQL Query insert <code>aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d</code> this string in <code>PASSWORD</code> field</p>
  
  <p><strong>INSERT command from Project</strong></p>
  
  <pre><code>def insert(password: String) = {
      DB.withConnection { implicit connection =&gt;
        SQL(
          """
            insert into user(PASSWORD) 
            values (
              SHA1('{password}')
            )
          """
        ).on(       
          'password -&gt; password       
        ).executeUpdate()
      }
    }
  </code></pre>
  
  <p>This insert operation stores the <code>PASSWORD</code> value as <code>f0e2d8610edefa0c02b673dcac7964b02ce3e890</code></p>
  
  <p><strong>What issue I am facing</strong></p>
  
  <p>Update my <code>PASSWORD</code> from project store value as <code>aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d</code> for password <code>hello</code> </p>
  
  <pre><code>SELECT USERNAME from USER WHERE PASSWORD = SHA1('hello') 
  </code></pre>
  
  <p>This query returns <code>null</code> in my project because it is considering <code>SHA1('hello')</code> as <code>f0e2d8610edefa0c02b673dcac7964b02ce3e890</code></p>