Re: Looking for specific data

Sweet. I can work with that. Thanks! Chris wrote: > DeadTOm wrote: >> There has to be an easier way to do this. I have a page with a list of >> 29 options utilizing checkboxes. The options that are checked get put >> into a mysql table as a 1 and the options not checked get entered as >> a 0. >> >> So the table looks like this >> >> id cs01 cs02 cs03 cs04 >> >> 1 0 0 1 0 >> >> 2 1 0 0 0 >> >> 3 0 0 0 1 >> >> >> The problem I'm running into is getting these things back out of the >> table. I only want the columns where the answer is a 1. > > Try this? > > [ requires mysql 4.0+ ] > > select id, 'cs01' as column_name from table where cs01='1' union all > select id, 'cs02' as column_name from table where cs02='1' union all > select id, 'cs03' as column_name from table where cs03='1' union all > select id, 'cs04' as column_name from table where cs04='1'; >