mysql and checkbox arrays

[derekm]

I have stored checkbox information to a mysql table via php implode and separted each checkbox with a "/" I want to now write a SQL statement that will group by each value in the column - note that a field may have 'blue/red/green' stored in it so I want it to list three groups blue, red, green in my result and not one group as blue/red/green). Thanks for the help!

Derek

[Anon]

You can try SELECT blabala FROM your_table WHERE checkbox_field LIKE '%blue%' for retrieving all the record which have blue checkbox checked.
You can store your checkbox values in SET field in which the predefined values are blue,red,green and retrieve the records using SLECT blablabla FROM your_table WHERE FIND_IN_SET('blue',checkbox_field)

Simon