MySQL Forums :: MySQL Workbench :: descrypt using select statement


Advanced Search

descrypt using select statement
Posted by: Ferdie Sison ()
Date: April 16, 2017 06:24PM

Hi,

Anyone can help on how to descrypt using select statement;

input row:

descrypt_column
YjBhNjY5MzE3MWQ4ZDJmOR89/ChuhaRG0gOVBlfHmPmJ3SbZfsKJhCOOPrs98ui0
YjBhNjY5MzE3MWQ4ZDJmObCJqm2JTsFxDnWytJqnFU7asBXQCIUY5cYlrdSMcii7
YjBhNjY5MzE3MWQ4ZDJmOV210xNkpkW5iwWq7ehrG5e4VVBsBkiWrmio0TyKIZna

output row:
descrypt_column
test@ethical.com
applied@ethics.com
provider@lead.com

I've notice that all rows having this "YjBhNjY5MzE3MWQ4ZDJmO" its millions row to identified.

Thank you in advanced.

Regards,
FPalero

Options: ReplyQuote


Subject Views Written By Posted
descrypt using select statement 78 Ferdie Sison 04/16/2017 06:24PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.