SQLize Online / PHPize Online  /  SQLtest Online

DELIMITER $ CREATE FUNCTION textDecrypt (input TEXT) RETURNS TEXT DETERMINISTIC BEGIN DECLARE crypt_str BLOB; DECLARE key_str BINARY(32); DECLARE init_vector BINARY(16); SET crypt_str = FROM_BASE64(input); SET key_str = 'lReilU0g+5QlG2Os7G3mdjsgt4faumrIXI1rQXqbuIQ='; SET init_vector = REPEAT('\0', 16); SET block_encryption_mode = 'aes-256-cbc'; RETURN AES_DECRYPT(crypt_str, key_str, init_vector); END $ DELIMITER ; SELECT textDecrypt('eyJpdiI6ImhGRGFSYmtyQlQxV2J0NHRIU2pzb3c9PSIsInZhbHVlIjoiZFd3QWtVNkRObll4Mk5TT2s0R2VWMGRCcWMvcXo5Y1A2K3pudFVDSWdGTT0iLCJtYWMiOiIxYThhZjQ3N2VkZmY5ODNlNTZhMjg1YzM5ZGFkNjEzMzA3YjUxZmM1MGE0NTk0ZjM5ZWM1ODE2M2RiZWI2MGNkIiwidGFnIjoiIn0');