Database encryption

Hi,
I have set up a database in mysql, the form i have created allows me to post to the database and the data fields are encrypted sha256.
I have then created a bootstrap form to display a table of the data but cant find out how to decrypt the data returned by the query.

How is this done? thanks in advance

You cannot “decrypt” a sha256 hash and that’s the idea of the hashing algorithms.

You need to use encrypt/ decrypt with password if you are encrypting data which needs to be decrtypted later