mysql> SELECT id,searchEngineUserID,searchEngineIdentifier,name,status FROM content_editor_bing.bce_campaign where name like '%STINVLC14%'; +------+--------------------+------------------------+-----------------------------------------+--------+ | id | searchEngineUserID | searchEngineIdentifier | name | status | +------+--------------------+------------------------+-----------------------------------------+--------+ | 7803 | 27389 | 170656567 | STINVLC14_1000000024_733_STINVLC14-1_GT | Active | | 7805 | 27389 | 170656568 | STINVLC14_1000000024_733_STINVLC14-1_GM | Active | | 7807 | 27389 | 170656569 | STINVLC14_1000000024_733_STINVLC14-2_GT | Active | | 7809 | 27389 | 170656570 | STINVLC14_1000000024_733_STINVLC14-2_GM | Active | | 7811 | 27389 | 170656571 | STINVLC14_1000000024_733_STINVLC14-3_GT | Paused | | 7813 | 27389 | 170656572 | STINVLC14_1000000024_733_STINVLC14-3_GM | Paused | +------+--------------------+------------------------+-----------------------------------------+--------+ 6 rows in set (0.00 sec) mysql> SELECT id,accountID,description,searchEngineStatusText from tsacommon.searchEngineAccounts where description like '%STINVLC14%'; +--------+-----------+-----------------------------------------+------------------------+ | id | accountID | description | searchEngineStatusText | +--------+-----------+-----------------------------------------+------------------------+ | 108489 | 28651 | STINVLC14_1000000024_733_STINVLC14-1_GT | Active | | 108491 | 28651 | STINVLC14_1000000024_733_STINVLC14-1_GM | Active | | 108493 | 28651 | STINVLC14_1000000024_733_STINVLC14-2_GT | Active | | 108495 | 28651 | STINVLC14_1000000024_733_STINVLC14-2_GM | Active | | 108497 | 28651 | STINVLC14_1000000024_733_STINVLC14-3_GT | Paused | | 108499 | 28651 | STINVLC14_1000000024_733_STINVLC14-3_GM | Paused | +--------+-----------+-----------------------------------------+------------------------+