so I have a table
userid,group1,group2,group3....group18
anyone user would have a group1 value or a group1 and group2 etc.
so
ether,admin,security,query
smith,admin,query,tax,entry
I need to output this into this format
ether,admin
ether,security
ether,query
smith,admin
smith,query
smith,tax
smith,entry
I had this same issue a long time ago, but cannot find the database to see the solution.
Any help is appreciated. thanks
userid,group1,group2,group3....group18
anyone user would have a group1 value or a group1 and group2 etc.
so
ether,admin,security,query
smith,admin,query,tax,entry
I need to output this into this format
ether,admin
ether,security
ether,query
smith,admin
smith,query
smith,tax
smith,entry
I had this same issue a long time ago, but cannot find the database to see the solution.
Any help is appreciated. thanks