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

On 09-04-2011 12:40, mada suresh wrote:
SELECT JS_Ident,JS_Resume_Id,JS_ALL,JS_AL,JS_AK,JS_AZ,JS_ AR
FROM Table
WHERE JS_ALL+JS_AL+JS_AK+JS_AZ+JS_AR > 0;


SELECT
JS_Ident,
JS_Resume_Id,
IF JS_ALL=1 THEN 'JS_ALL' ELSE '' END IF,
IF JS_AL=1 THEN 'JS_AL' ELSE '' END IF,
IF JS_AK=1 THEN 'JS_AK' ELSE '' END IF,
IF JS_AZ=1 THEN 'JS_AZ' ELSE '' END IF,
IF JS_AR=1 THEN 'JS_AR' ELSE '' END IF
FROM Table
WHERE JS_ALL+JS_AL+JS_AK+JS_AZ+JS_AR > 0;



--
Luuk

On 4/9/2011 6:40 AM, mada suresh wrote:
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 (AT) attglobal (DOT) net
==================

it is possible for only low number columns ... what we do for large
number of columns

On 09-04-2011 14:17, mada suresh wrote:
please,
learn English,
learn MySQL,
and re-ask your question in such a way that any one can understand what
you want to do .....

--
Luuk

On 09-04-2011 15:16, Luuk wrote:
If you give more text, and some examples of what you want to do, the
degree of English is less important..

--
Luuk

On 4/9/2011 8:17 AM, mada suresh wrote:
Normalize your database properly.

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

then how could others replied they could understand my thoughts,, dont
behave like this

On 4/14/2011 1:39 AM, mada suresh wrote:
I agree with Luuk - I had a very hard time figuring out what you want to
do - and even then I was guessing.

And if you expect to get help here, don't be an anal orifice.

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

mada suresh <madudatabase (AT) gmail (DOT) com> writes:

What others? What replies? What thoughts? Behave like what?

Please quote the relevant parts of the message you're replying to - taken
by itself, what you said makes absolutely no sense.

sherm--

--
Sherm Pendley
<http://camelbones.sourceforge.net>
Cocoa Developer