Results 1 to 5 of 5
Thread: search a SET column?
Jan 17, 2005, 09:25 #1
- Join Date
- Jan 2005
- 0 Post(s)
- 0 Thread(s)
search a SET column?
I have a table with two columns, the first column is of type VARCHAR and the second of type SET.
person3 group1, group2
I want to retrieve everyone in "group1"...
SELECT * FROM mytable WHERE column2 = 'group1';
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?