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]