how do i get field name from this table

Time Stat1 Stat2 Stat3
0905 11111 11111 11111
0906 11111 00000 11111

i want to get the field name Stat1 & Stat 3 
from the 0906 row which have 11111 as value

I expect the result to be
STAT1
STAT3


Select xxx from table_time where xxx=11111 and Time=0906;

can someone help me?  

-- 
Chenri J
Taman Palem Lestari B18 - 19A
(021) 926 68651 - Esia jadi bisa SMS

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to