Lancer Emotion 16 wrote:
I have this table named users :
+ | ID | user | pass | thegroup | firstname | surname | enabled +----+--------+----------------------+----------+-----------+---------+--------- | 1 | Admin | *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");
that one should work, except...
When i do :
select password('admin')
i get : *4ACFE3202A5FF5CF467898FC58AAB1D615029441
You wouldn't maybe guess that your "pass" field above is too small? :-)
FWIW, -- Hassan Schroeder ----------------------------- [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
dream. code.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
