encryption - mysql results with some encrypted data -

is possible results of query , decrypt 1 column?

for example:

name | username | date     | password ted  | teddy01  | 01/01/13 | s4drcfgbh76

so want results of column (above) , it's regular text apart password aes_encrypted.

i left comment saying why bad way store passwords, since hate when people answer with, "don't that," figured tell how different instances.

in mysql can call aes_decrypt.

a sample query be:

select username, created_date, aes_decrypt(encrypted_column_data,key) decrypted_data table username = '$username'

this give results like:

username    | created_date | decrypted_data mitnosirrag | 2012-02-03   | "here unencrypted string"

Bready