Set @key='F696282AA4CD4F614AA995190CF442FE';
Set @MyCrStr=AES_Encrypt('texttexttext',UnHex(@key));

SELECT packet_binary,length(mid(packet_binary,5))/16 as LEN,
hex(AES_Decrypt(mid(packet_binary,5,16),UnHex(@key))) as h1,hex(AES_Decrypt(mid(packet_binary,5,32),UnHex(@key))) as h2,hex(AES_Decrypt(mid(packet_binary,5,48),UnHex(@key))) as h3
,hex(AES_Decrypt(mid(packet_binary,5,64),UnHex(@key))) as h4,hex(AES_Decrypt(mid(packet_binary,5,80),UnHex(@key))) as h5,hex(AES_Decrypt(mid(packet_binary,5,96),UnHex(@key))) as h6
,hex(AES_Decrypt(mid(packet_binary,5,112),UnHex(@key))) as h7#,hex(AES_Decrypt(mid(packet_binary,5,128),UnHex(@key))) as h8,hex(AES_Decrypt(mid(packet_binary,5,144),UnHex(@key))) as h9
,hex(Replace(AES_Decrypt(Concat(mid(packet_binary,5),@MyCrStr),UnHex(@key)),'text','')) as DecryptedStr
FROM `dump` T
