Re: password()

[Jay J]

----- Original Message -----
From: Sun JunXu <Junxu@stripped>
To: <mysql@stripped>
Sent: Thursday, September 16, 1999 12:53 AM
Subject: password()


> hi,
> in mysql--user, can use password("password") ,
> can I use it in a normal table? how can I read out it?
> I used it in a table,  when I tried compare this encoded string to string
> "password", result is they are not equal,

It's completely a one way operation, like crypt (if I'm not mistaken).

You need to use MySQL's function:

SELECT name FROM users WHERE name = 'something' AND password =
PASSWORD('plaintext')

.. or some variation of that. Does that help? ;)

-Jay J