Re: Searching on a field from multiple rows matching a groupId

[Jerry Malcolm]

CREATE TABLE IF NOT EXISTS `mytable` (
`NDX` int(11) NOT NULL AUTO_INCREMENT,
`GROUPID` int(11) NOT NULL,
`COLX` varchar(50) NOT NULL,
PRIMARY KEY (`NDX`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mytable`
--

INSERT INTO `mytable` (`NDX`, `GROUPID`, `COLX`) VALUES
(1, 1, 'aaa bbb abc ccc'),
(2, 1, 'ddd eee fff'),
(3, 1, 'ggg xyz'),
(4, 2, 'abc hhh iii'),
(5, 2, 'jjj kkk'),
(6, 2, 'lll mmm');
COMMIT;