EXPLAIN SELECT retailers . * 
FROM op_names, retailers
WHERE op_names.retailer_id = retailers.retailer_id && op_names.store_name LIKE '%Bennigan\'s%' || retailers.store_name LIKE '%Bennigan\'s%';

id  select_type  table  type  possible_keys  key  key_len  ref  rows  Extra  
1 SIMPLE retailers ALL PRIMARY NULL NULL NULL 5444   
1 SIMPLE op_names ALL retailer_id NULL NULL NULL 6858 Using where 


-- 
-- 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 (retailer_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;


-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5445 ;