how to decrypt a md5 data in mysql query? [duplicate]

This question already has answers here: Closed 10 years ago.

Possible Duplicate:

Is it possible to decrypt md5 hashes?

I have a table which is having md5 encrypted data in it. I have to copy that da开发者_如何学JAVAta in another table but in decrypted form. How can i do that in mysql query??

---

You cannot decrypt an md5 hashed string, since it is a one way algorithm. But they can be converted using reverse lookup using mysql. You can refer various online decrypts to find a best solution.

---

MD5 is not a reversible encryption algorithm. It's a one-way hash. The aim of a hash is to allow you to verify (with some degree of uncertainty) whether someone had the same original information as was used to create the hash. It does not allow you to get back from the hash to the original information.

---

MD5, as others have said here, is not reversible. Having said that, there are databases that contain sort of dictionaries to allow reverse lookup on MD5 hashes.

Check it out: http://tools.benramsey.com/md5/

More info here.

---

NO, md5 data can not be decrypted.

---

No,

MD5 is a HASH algorithm so, it is not possible to decrypt. To test if some value is correct, you compare the MD5(value) to stored MD5, but it is impossible to extract the original value from MD5.

---

If you decrypt the data from MysQL what would be the point of crypting it? You can only compare to a MD5 password with uncrypted data.

You can ofcourse crack the MD5, read http://alan.blog-city.com/cracking_mysqls_md5_function__within_seconds.htm

But you kinda missed the whole point of encrypting your password :/