SELECT * NOT password FROM table??? how to do that

hi, i want to select all info from a table - one row.
Like SELECT * (other than the password) FROM table
is that possible? other than doing it by selecting each row speperatly

 

how about keeping the password in a separate table?

 

You wither have to select each column individually, or you can just not use that column any further in your script. I don't think there is any way to exclude a column from a select statement.

 

Depending on your database engine, you could use a view to select certain columns. Either way, best choice is to ALWAYS type out all the column name for best performance. Good luck.

 

thanks guys

 

You should be storing password in their own table in as a hashed value to ensure security...see here for more details in a mysql db...

http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html

 

@bochgoch: hashed passwords I agree with, but you could explain a bit more about why they should be in their own table? Just curious as I can't see why it would be more secure (plus it goes against database normalisation I feel).

 

You can then set distinct user rights to the password table then.

 

Oh I see... so you use one database user for verifying passwords and another for everything else then? I can see that, though I don't think I'm going to be doing it any time soon