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 … 
 
 
 


Reply via email to