Hello everbody,i have a problem with mysql and i wish you could help me.
I have this table named users :
+----+--------+----------------------+----------+-----------+---------+---------
+
| ID | user | pass | thegroup | firstname | surname | enabled
|
+----+--------+----------------------+----------+-----------+---------+---------
+
| 1 | Admin | *4ACFE3202A5FF5CF467 | 1 | Mr | Admin | 1
|
| 2 | admin2 | *4ACFE3202A5FF5CF467 | 1 | Mr | Admin | 1
|
+----+--------+----------------------+----------+-----------+---------+---------
The password in both cases are : admin .
When i do any of this querys :
select * from users where pass=password("admin");
select * from users where pass='admin';
select * from users where pass="password('admin')";
i get an empty set, i dont know why.
When i do :
select password('admin')
i get : *4ACFE3202A5FF5CF467898FC58AAB1D615029441
Please help me.
Thanks
--
lancer emotion 16
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
