title: Hashing an entire column using sha512
body: <p>I have a table with three columns named: Question, Answer, Hashed.  I want to update the Hashed column with the Answer column hashed using sha512.</p>
  
  <p>I've tried to do the update directly from my MySql database using this syntax, but it didn't work:</p>
  
  <p>UPDATE TableName
  SET Hashed = SHA512(Answer)
  WHERE Hashed IS NULL</p>
  
  <p>I know the syntax is wrong but not sure why. </p>
  
  <p>Thanks in advance for your help!</p>
  
  <p>R</p>