[SOLVED] select all except from MySQL

[ShiloVir]

is there a way to select all data from MySQL except for 1 field. See, in the MySQL conn I got about 200 columbs. is there a way to select all data except for the 'password' columb. This is the code im using atm:

 

<?php
$sql = "SELECT * FROM auth_users LIMIT $offset, $rowsperpage";   
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);  
?>

[genericnumber1]

SELECT column1, column2, column3 FROM ...

[ShiloVir]

yeesh! for all 200 columbs. haha. Forget security! ima just pull all data! haha. take that!

 

TOPIC SOLVED. YET NOT IN COMPLETNESS.....

[dezkit]

is there a way to select all data from MySQL except for 1 field. See, in the MySQL conn I got about 200 columbs. is there a way to select all data except for the 'password' columb. This is the code im using atm:

 

What's a columb?

 

[.josh]

First off, if you have 200 columns in 1 table I'd sit down and reconsider your table structure.  There's more than likely any number of ways to break that down into several tables.  But disregarding all that, if you have 200 tables and you are going to actually use all but 1, then you may as well just select *.