Re: How can I return column-name?

[Roland Bouman]

There's another way altogether. The mysql database contains a columns_priv table (or something like that, sorry, haven't got a mysql runnning here so i can't be specific right now).

If it is permissable to grant a user select access to that table, you can use that table to see what columns a table has:

select distinct column_name
from mysql.columns_priv
where host = '%'
and db = database()
and user = current_user()
and table_name = 'some table'

or something more appropriate for your system