Code:
MySql Table:

ctyID       county            s7        s8       s9        s10
1           County A          n         n        n         n
2           County B          y         n        n         n
3           County C          n         y        n         n
4           County D          y         n        y         n
I would like select a county and have the column name returned if the field contains a 'y'.

For example: select "County D" and the query would return "s7" and "s9".

How do I create a SQL query that will accomplish this task?
Thank you!