Mine

EXPLAIN SELECT retailers . * FROM op_names, retailersWHERE 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 ;