Query on encrypted fields

I need to be able to query on an encrypted field. I am encrypting an API key in the database and need to take the key given when a client host requests API access and lookup that key in the database. Currently I would have to do this manually but I can make this nicer by doing it transparently during the query.