mysql> select * from locationExtension where campaignName like '%OAUTH02%'; +------+--------------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+----------------+----------------------------+ | id | locationIdentifier | campaignIdentifier | campaignId | campaignName | streetAddress1 | streetAddress2 | cityName | provinceName | countryCode | postalCode | phoneNumber | companyName | searchEngineUserIdentifier | +------+--------------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+----------------+----------------------------+ | 2315 | 335997395 | 194370515 | 1007981 | OAUTH02_1000000024_733_OAUTH02-1_GM | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | TEST Branch DN | 9325145061 | | 2316 | 335997515 | 194370395 | 1007980 | OAUTH02_1000000024_733_OAUTH02-1_GT | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | TEST Branch DN | 9325145061 | +------+--------------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+----------------+----------------------------+ 2 rows in set (0.00 sec) mysql> select * from locationExtension where campaignName like '%OAUTH02%'; Empty set (0.00 sec) mysql> select * from locationExtensionFeed where campaignName like '%OAUTH02%'; +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------------+--------------+-------------+------------+-------------+-------------+----------------------------+ | id | feedId | feedItemId | feedMappingId | campaignIdentifier | campaignId | campaignName | streetAddress1 | streetAddress2 | cityName | provinceName | countryCode | postalCode | phoneNumber | companyName | searchEngineUserIdentifier | +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------------+--------------+-------------+------------+-------------+-------------+----------------------------+ | 1030 | 20306860 | 843664090 | 22068969 | 194370515 | 1007981 | OAUTH02_1000000024_733_OAUTH02-1_GM | Liberty House, 222, Regent Street | Oxford Circus, Oxford | United Kingdom | London | GB | W1B 5Tr | NULL | | 9325145061 | | 1031 | 20306860 | 843663190 | 22068969 | 194370395 | 1007980 | OAUTH02_1000000024_733_OAUTH02-1_GT | Liberty House, 222, Regent Street | Oxford Circus, Oxford | United Kingdom | London | GB | W1B 5Tr | NULL | | 9325145061 | +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------------+--------------+-------------+------------+-------------+-------------+----------------------------+ 2 rows in set (0.00 sec) mysql> select * from locationExtensionFeed where campaignName like '%OAUTH02%'; +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+-------------+----------------------------+ | id | feedId | feedItemId | feedMappingId | campaignIdentifier | campaignId | campaignName | streetAddress1 | streetAddress2 | cityName | provinceName | countryCode | postalCode | phoneNumber | companyName | searchEngineUserIdentifier | +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+-------------+----------------------------+ | 1030 | 20306860 | 843664090 | -1 | 194370515 | 1007981 | OAUTH02_1000000024_733_OAUTH02-1_GM | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | | 9325145061 | | 1031 | 20306860 | 843663190 | -1 | 194370395 | 1007980 | OAUTH02_1000000024_733_OAUTH02-1_GT | Liberty House, 222, Regent Street | Oxford Circus, Oxford | London | United Kingdom | GB | W1B 5Tr | NULL | | 9325145061 | +------+----------+------------+---------------+--------------------+------------+-------------------------------------+-----------------------------------+-----------------------+----------+----------------+-------------+------------+-------------+-------------+----------------------------+ 2 rows in set (0.00 sec)