Long time reader, first time poster. And I start with quite a cryptic one!
What I'm seeking to do is encrypt a string with the SHA-256 algorithm, and hash it with a key.
I discovered someone had done some excellent work in creating an algorithm for "normal" SHA-2 encryption as a stored function at: http://blog.darkrainfall.org/sha-256-in-mysql/ which will probably be of help to others, but I need to be able to do it with a key.
Anyone know if this is possible? I'm a completely newbie to encryption I'm afraid.
I'm using mySQL 5.1 on Windows 2003 server.
Cheers.