Stuff

SELECT retailers.store_name FROM op_names, retailers WHERE op_names.retailer_id = retailers.retailer_id && op_names.store_name LIKE '%Popeyes%' || retailers.store_name LIKE '%Popeyes%'-- -- Table structure for table `op_names`-- CREATE TABLE `op_names` (  `op_name_id` int(7) unsigned NOT NULL auto_increment,  `retailer_id` int(5) unsigned NOT NULL,  `store_name` varchar(300) NOT NULL,  `gla` varchar(50) NOT NULL,  PRIMARY KEY  (`op_name_id`),  KEY `retailer_id` (`op_name_id`,`retailer_id`,`store_name`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6859 ;-- -- Table structure for table `retailers`-- CREATE TABLE `retailers` (  `retailer_id` int(5) unsigned NOT NULL auto_increment,  `store_name` varchar(300) NOT NULL,  `address1` varchar(300) NOT NULL,  `address2` varchar(300) default NULL,  `city` varchar(100) NOT NULL,  `state` varchar(2) NOT NULL,  `zip_code` varchar(10) NOT NULL,  `website` varchar(150) default NULL,  `ttl_stores` int(8) NOT NULL,  `franchised_stores` int(5) default NULL,  `gla` varchar(25) NOT NULL,  `retail_classification` text NOT NULL,  `loc_considered` text NOT NULL,  `pref_cotenants` text,  PRIMARY KEY  (`retailer_id`),  KEY `retailer_id` (`retailer_id`,`store_name`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5445 ;