md5() ...
| From: | Reymond | Date: | Thu, 15 Aug 2002 04:22:05 +0000 |
| Subject: | md5() ... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-112666@lists.php.net to get a copy of this message | ||
I have login = sysdata and
password = sysdata on md5 function
How to select md5 function
mysql> select COUNT(*) AS result from User where login = sysdata" and
password = md5("sysdata");
+-------+
| result |
+-------+
| 0 |
+-------+
1 row in set (0.00 sec)
I wanna the result display 1 like this one
mysql> select COUNT(*) AS result from User where login = "sysdata";
+--------+
| result |
+--------+
| 1 |
+--------+
1 row in set (0.00 sec)
help