I’ve created a patch for MySQL 5.0.33 to provide a function SHA2().
Download it here:
It really just calls out to the OpenSSL library for the digest functions. So you have to build MySQL from source with OpenSSL support enabled.
You can use the function in SQL syntax like:
SELECT SHA2(‘message’, 256);
The second argument is 224, 256, 384, or 512, depending on what digest algorithm you want to use. If you pass 0 as the second argument, it uses SHA-256.
This is my first code contribution to MySQL. I’d be grateful if someone wants to review it and let me know if it needs any changes.
UPDATE 2/5/2007: I re-packaged the patch, excluding more of the MySQL generated files. Thanks to Stewart Smith @ MySQL for the suggestion.
UPDATE 12/3/2010: MySQL 5.5.8 has been released for General Availability, including my SHA2() patch. Happy day!