Quote:
I have setup my password as hash and stored into the database as a varchar
But i want to retrieve and convert it back to text as it was
How do i do it
Short answer: you can't !
MD5 hash is a one way process, like any other hash. you can't reverse it, it is by design.
Contrary to encryption which can be decrypted.