Re: [newbie] how do I force a numerical comparison of two md5 strings

2002-10-31 Thread Michael T. Babcock
Benjamin Pflugmann wrote: So what's left is that you save the real md5 string instead of it's hex representation, e.g. in a CHAR BINARY. That's easiest if you have the binary representation on the client side. I see no easy way of doing it in MySQL if you only have the hex rep (you could split it

Re: [newbie] how do I force a numerical comparison of two md5 strings

2002-10-31 Thread Benjamin Pflugmann
Hello. On Thu 2002-10-31 at 13:54:18 -0500, [EMAIL PROTECTED] wrote: > Am I right in assuming that comparing two md5 strings would be faster > if they were compared as two hexadecimal numbers than if they were > compared as two strings? > > If so, is there any way to insist on this in a SQL que

[newbie] how do I force a numerical comparison of two md5 strings

2002-10-31 Thread Walter Lee Davis
Am I right in assuming that comparing two md5 strings would be faster if they were compared as two hexadecimal numbers than if they were compared as two strings? If so, is there any way to insist on this in a SQL query? I am using PHP, and would like to know from that perspective if it makes an