MySQL Functions in WHERE clause (OT)
| From: | Ben Wiechman | Date: | Fri, 29 Dec 2000 21:10:18 +0000 |
| Subject: | MySQL Functions in WHERE clause (OT) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-32219@lists.php.net to get a copy of this message | ||
Anyone have an idea why the following won't work for me...
I have a table with two fields, login & password.
Using the following line to insert values into this table.
"INSERT INTO auth (login, password) VALUES ('user', PASSWORD('pass'))"
Now, when I try to select by password from the table using the following, I
get nothing. It doesn't find the correct row.
"SELECT * FROM auth WHERE password = PASSWORD( 'pass' )"
Can anyone see anythign wrong with this? I'm stumped.
Ben