From: mos
Date: October 26 2007 2:17pm
Subject: How to encrypt Text and still be able to use full text search?
  3rd Attempt ++
List-Archive: http://lists.mysql.com/mysql/209696
Message-Id: <6.0.0.22.2.20071026091456.06483418@pop.mts.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

I posted this message twice in the past 3 days, and it never gets on the 
mailing list. Why?
Here it is again:

I have a Text field that contains paragraph text and for security reasons I 
need to have it encrypted. If I do this, how can I still implement full 
text search on it?
Also, I have a lot of Float columns that need to be protected but the user 
has to use comparison operators like ">" and "<" on them. Any recommendations?

TIA
Mike