Decrypting data in a MySQL table using a standard query and a BS4 Table

HI all,
Please can someone help as I’m chasing my tail.

I have created a database table on a MySQL server, two of the data fields contain sensitive information.
when posting to the database i can encrypt with password and the data appears on the server encrypted.

Problem is now I want to decrypt when retrieving the data in a query but i do not have the option within the query builder to decrypt with password so cant view the data on the client screen.
I understand that SHA with salt and hash is one way but by password is supposed to be both…

Thanks in advance