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 any difference. Single-quoted variable name versus double-quoted, for example? Any magic words to force the comparison to be done in the numerical space?

Thanks in advance,

Walter


---------------------------------------------------------------------
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

Reply via email to