MySQL Forums
Forum List  »  Newbie

Re: How to get column/field names with select
Posted by: Felix Geerinckx
Date: August 11, 2005 07:41AM

dump3 wrote:

> I'm roughly following your example -- but am a tad confused.

> Is the foo table a list of the field names -- and then the WS_CONCAT returns a string I can parse
> which has the ID of the "real" row/record -- followed by the field name from foo IF it matched
> -- or NULL if not?

It's ready to run. Try it and look at the output. ('foo' is the 'mytable' of your question).

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to get column/field names with select
August 11, 2005 07:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.