On Tuesday 09 April 2002 2:13 pm, Andrew Hazen wrote: > Hi, > Can I use the MD5 function in the where clause, as in: > > Select * from table where md5(column)=value > ????
I see no reason why not but note that you are likely MUCH better off storing column as an MD5 hash, computing the MD5 of value, and then doing your select on that. That way, you won't have to calculate an MD5 value n times, where n is the number of rows in your table. sql filter daemon sucks. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
