Hi,

I have a huge table with a lot of fields,
From tat table i have select field1.field2.....field-n
Now i use select * query, but i need to select all except(field-1,field-

If you find a way of doing it, let me know!

(But unless you are writing sql by hand, shouldn't be a problem...?

I can say for sure - no way from MySQL (or any other DBMS) side. The only way is to manage metadata on PHP side -
select COLUMN_NAME from information_schema.columns where TABLE_NAME = yourtable and TABLE_SCHEMA = yourschema
and form your own field list with regard of excepted fields.