HI MD5 would be a good way of doing it. Just add a column to your user table and
UPDATE users SET subscribed = 0 WHERE encryptedID = "md5 hash here" HTH Peter > -----Original Message----- > From: Scott Haneda [mailto:[EMAIL PROTECTED] > Sent: 04 August 2004 03:37 > To: MySql > Subject: Best options for unique string > > > I am building a mailing list manager, using mysql 4 at the moment. I want > to have a simply web interface where one can remove themselves from a > mailing list. This will most likely be supplied as a link in a email that > will be sent to them when they email in and request info about a mailing > list. What I don't want is to have a link like [EMAIL PROTECTED] > but would rather mask that email address as a unique string. > > I was thiking that on INSERT I can use a timestamp with some > random and that > should be pretty much guaranteed to be unique, I could just use the PK but > then people could fiddle the url and mess with others accounts. So I need > something non sequential, rather random looking at least, perhaps somehow > make mysql case sensitive on this one as well. (How does one make > mysql case > senseitive on a field?) > > Would MD5(user_email_address) pretty much be what I am after? > > I don't suppose there is any way to "un-MD5" something? > -- > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED] Novato, CA U.S.A. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
