MD5('test')

[thebay]

INSERT INTO users (user,passwd) VALUES ('test',MD5('test')) ;
shows the record added;

but when I do

select count(*) from users where passwd=MD5('test');

shows 0 (no record)

Why???

[il_cenobita]

I have test your problem and it's ok

what is the type of passwd? i have test it whit varchar(250)

[laserlight]

If you're using md5 hash as a hexadecimal string, then you would only need VARCHAR(32)