Page 1 of 1

MySQL and base64_encoded content

Posted: Wed Aug 24, 2005 4:34 am
by apedcen
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.

Posted: Wed Aug 24, 2005 7:14 am
by feyd
options I see:
  1. transformt all the encoded strings back to natural form
  2. create a stored procedure/function/method that can perform the decode and search
  3. continue doing it the "old fashioned" way :)