Topic: Search encrypted data

I have a few fields in the table encrypted. How can I search the table? I believe you can create a new table on the fly in mysql and store that data in plain text temporary without encryption, but never done that. Is that possible?