From: Thomas Wana
Date: March 15 1999 8:08pm
Subject: how to select password(...)?
List-Archive: http://lists.mysql.com/mysql/278
Message-Id: <001e01be6f1f$8ec99f00$86e76ac2@lukeskyw>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello!

Sorry for asking, I know there is a thread about that, but that
couldn't help me...

I've got a table 'user':
---------------------------------|
| nr | Name     | Pass           |
|--------------------------------|
|  0 | t.wana   | a3245jybdwejre |
|  1 | m.resch  | klj879879348aa |
----------------------------------

I've inserted the values with the following command:
insert into user values (0,"t.wana",password('asdf'));
insert into user values (1,"m.resch",password('sdfg'));

Now imagine the User t.wana sends his username and password over a web-
interface and the program should decide wether it lets him through or not :)

I thought that would work:
select * from user where Name=[name from web-interface] and
   Pass=password('[password from web-interface]');

When there is a row returning, then the username and password are correct.

My problem: there is always an "empty set" returning.

Could you please help me on that?

Thanks a lot,
Thomas