CREATE TABLE `testtable` ( `component_name` varchar(100) NOT NULL default '', `component_type` tinyint(4) NOT NULL default '0', `component_id` int(11) NOT NULL auto_increment, PRIMARY KEY (`component_id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; insert into testtable (component_name,component_type) values ('a.comp',0); insert into testtable (component_name,component_type) values ('b.comp',0); insert into testtable (component_name,component_type) values ('c.comp',0); insert into testtable (component_name,component_type) values ('x.comp',1); insert into testtable (component_name,component_type) values ('y.comp',1); insert into testtable (component_name,component_type) values ('z.comp',1);