How to convert hex chars to byte array in mysql
There is no such thing as an "array" in MySQL.

Perhaps you want UNHEX(SHA1("stuff")) ?  That will provide a 20 bytes, and could be stored, for example, into a BINARY(20) column.