04-01-2018, 08:44 PM
MySQL DECODE() & ENCODE() => github source
ENCODE:
OUT:
DECODE:
OUT:
The database I have encrypted passwords, i know some of the passwords
Can I get salt with which passwords have been encrypted?
(to decrypt the remaining passwords)
ENCODE:
Code:
INSERT INTO users(pass) VALUES (ENCODE('pass123','salt'))
Code:
q+ÀC[
DECODE:
Code:
SELECT DECODE(pass,'salt') as 'decode pass' FROM users
Code:
pass123
The database I have encrypted passwords, i know some of the passwords
Can I get salt with which passwords have been encrypted?
(to decrypt the remaining passwords)