MySql password()

[wxdqz]

Hi,

i have a problem with encrypted passwords in mysql table.

i put them in:

insert into my_pass (login, pass) values (\"martin\", password(\"secret\"));

and when i query: select * from my_pass; I can see username and encrypted password, but i cannot get the passwords out of there!
so:
select * from my_pass where login='login' and pass=password('password');

empty set
any ideas?

regards,
martin