title: How to use password() in sql?
body: <p>I am trying to verify user login my matching the input password to the password input by user</p>
  
  <p>My insert query:</p>
  
  <pre class="lang-sql prettyprint-override"><code>insert into login (Emp_id, Emp_Fname, Emp_Lname, Username, Password) values (5, 'TestFName', 'TestLName', 'Test', password('april'));
  </code></pre>
  
  <p>it stores the password as this value : </p>
  
  <pre><code>*72B46CDA233C759A88BEF81F59F66D78B26B2848
  </code></pre>
  
  <pre class="lang-sql prettyprint-override"><code>select * from login where password = '*72B46CDA233C759A88BEF81F59F66D78B26B2848';  -- this line shows me the result
  
  select password('april'); -- this returns *72B46CDA233C759A88BEF81F59F66D78B26B2848
  
  select * from login where password = 'password(april)'; -- this returns an empty set
  </code></pre>
  
  <p>Is there any alternative to this line of code?</p>