Help Me Out W/ My Query.. Should I Use Fetch?

hi,


i want to be able to get the columns from my table except for its pk. the long method is to selecting all columns by listing them one by one right? but what if i got 100 columns..

so.. i wanted to use the information_schema..

i have:

use dbase;
select column_name
from information_schema.columns
where table_name = 'table1'
and column_name != 'pkid'

so there i'm listing the columns, but how am i suppose to select those columns from my real table?



thanks in advance!