How to transfer the data type from binary(32) to string?

i find the table named 'query_execution' in the configed mysql database, and the column named 'hash' is stored as binary(32) in this table. how can i transfer it to string type so i can read it in evidence?

Hi @yakunhan
The hash is nothing you can read, it's just a computer generated value.
You just need to convert/cast the column to "read" it:

SELECT CONVERT(`hash` USING utf8), CAST(`hash` AS varchar(32)) FROM `query_execution`

i tried it but nothing changed. mysql version is 8.0

@yakunhan Use HEX(hash) to make it readable.

done! you gave me a professional technical support , thanks a lot