----- Original Message ----- From: "Scott Haneda" <[EMAIL PROTECTED]> To: "MySql" <[EMAIL PROTECTED]> Sent: Tuesday, August 03, 2004 10:37 PM 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? Try Googling or searching for "GUID" on pages that cover your favourite programming language, e.g. "Java" "GUID". If I recall correctly, "GUID" stands for "Guaranteed Unique ID" and is usually based partly on the MAC address for your computer which is unique. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]