See the section of the documentation on the password function.
Insert into users (username, password) values
('joesmith',password('somepassword'));
It will encrypt your passords. then you select using the same function.
select username, password from users where username = 'joesmith' and
passw
At 7:24 AM +0500 1/22/01, Muhammad Farhan Ghazi wrote:
>How one can make a field encrypted in a table, so that it cannot
>even be seen using the select statement? I have a field in which I'm
>storing passwords and I don't want it to be visible.
Making it visible or not isn't a matter of encrypt
