MySQL and base64_encoded content
Posted: Wed Aug 24, 2005 4:34 am
Hi,
I need to perform string search within mysql database content, which is encoded with base64. Search subject is not encoded, of course. In general, I have to select all of the content in the table, then decode every result with base64_decode and to perform search within decoded string.
Is somehow possible to do this without selecting all the records (table is huge) and to search within encoded strings?
Thanks.
I need to perform string search within mysql database content, which is encoded with base64. Search subject is not encoded, of course. In general, I have to select all of the content in the table, then decode every result with base64_decode and to perform search within decoded string.
Is somehow possible to do this without selecting all the records (table is huge) and to search within encoded strings?
Thanks.