Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #538

Re: Want column name

Show all headers | View raw

On 4/9/2011 6:40 AM, mada suresh wrote:
> hi friends,
>                   i want column names which has the value 1 in row.....
> the may have multiple column,, if more then 1 present then i want each
> names,,,, please help me,,, my table is here,,,
>
> http://pastie.org/1775025
>
> please can you help any one,, i tried many times,,, but i couldn't do
> it,,, hence i have come here
>
>                                                       Thank you
>

Normalize your data properly and you won't have this problem.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Want column name mada suresh <madudatabase@gmail.com> - 2011-04-09 03:40 -0700
  Re: Want column name Luuk <Luuk@invalid.lan> - 2011-04-09 13:52 +0200
  Re: Want column name Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-09 08:09 -0400
  Re: Want column name mada suresh <madudatabase@gmail.com> - 2011-04-09 05:17 -0700
    Re: Want column name Luuk <Luuk@invalid.lan> - 2011-04-09 15:16 +0200
      Re: Want column name Luuk <Luuk@invalid.lan> - 2011-04-09 15:18 +0200
      Re: Want column name mada suresh <madudatabase@gmail.com> - 2011-04-13 22:39 -0700
        Re: Want column name Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-14 06:08 -0400
        Re: Want column name Sherm Pendley <sherm.pendley@gmail.com> - 2011-04-14 15:23 -0400
        Re: Want column name Luuk <Luuk@invalid.lan> - 2011-04-14 22:13 +0200
    Re: Want column name Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-09 09:34 -0400

csiph-web