Select no more then 10 columns from a table in mysql?

[deep]

Hello,

Got a table thats loaded with columns. My code:

$q = mysql_query("SELECT something FROM table ORDER BY best");
while($r = mysql_fetch_array($q)){
// do something
}

Can i add something to the SQL to make it only pick the 10 best columns?

Thanks.

[coreyp_1]

do you mean something like "SELECT something FROM table ORDER BY best LIMIT 10"