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]