I have a list of columns of table that holds boolean values. consider a,b,c,d,e,f,g,h as column names with YES or NO values. I want to query and list column names whose value is YES. can some write a mysql query that can list the columns. if a column has an underscore i want to replace underscore with space or " ".can somebody write the required script using php.
Thanks for help.