Just do all your searching/sorting in PHP.. it would be slower, and if your
dataset is very large (sounds like it might be the case) it would be
impossible.. So that might be out of the question..
A bit of system engineering might find a solution too, consider which fields
you need to
Oh! Also, there's built in mysql functions for encryption, I forgot about
that, so you can still search, like this:
insert into table set name_field = AES_ENCRYPT('Some name', 'secret key');
select * from table where AES_DECRYPT(name_field,'secret key') LIKE '%some';
Make sense? You'll want an