search a SET column?

Customer Support Database Support
1

I have a table with two columns, the first column is of type VARCHAR and the second of type SET.

column1(VARCHAR) column2(SET)
person1 group1
person2 group2
person3 group1, group2

I want to retrieve everyone in “group1”…

SELECT * FROM mytable WHERE column2 = 'group1';

Which returns only person1 and not person1 and person3 as I want.

I have searched through the manual and found several ways to search for data matching several criteria (ANY, IN, SOME, ALL) but not “the other way around”.

I guess what I’m really asking is how do I search within a column of type SET?

2

I have come to a solution (having posted as well at two other forums)

The solution in FIND_IN_SET

More information can be found at either of these two sites as well as in the MySQL Manual:

http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html
vbmysql.com

3

Makes sense since column2 != group1
It was eaqual to group1 & group2 - I suspected you’d need some kind of an IN in there somewhere…