Quick question: selecting all but one.

[matthewhaworth]

Say I have, iD, username, password, aboutme, name, age, blah.

 

And I want to select * BUT password, how can I do it?

 

Edit: without listing them..

[teng84]

add a where clause

 

sample i use * but dont use it its good for sample only

 

select * from table where field = your damnpassword

 

[matthewhaworth]

add a where clause

 

sample i use * but dont use it its good for sample only

 

select * from table where field = your damnpassword

 

 

But on mysql_fetch_assoc, that'll return the key 'password' still.

[btherl]

You can't, and I can't imagine why you would want to.  The query will not be any faster, and you can always remove the password from the result.  You could also list the columns, which gives you self-documenting code.