Query: decrypting in where

[TheConeHead]

I have an encrypted column. I need to make a query that has a where inwhich I need to 'where' the encrypted column.

I am trying:

SELECT AES_DECRYPT(uname,'key') as suname,  AES_DECRYPT(pword,'key') as spword FROM table where uname = '$unameI' AND pword = '$pwordI'

this obviously is not working... how do I do this?

 

[TheConeHead]

sorry - I got it:

SELECT AES_DECRYPT(uname,'key') as suname,  AES_DECRYPT(pword,'key') as spword FROM table where AES_DECRYPT(uname,'key') = '$unameI' AND AES_DECRYPT(pword,'key') = '$pwordI'