Skip to content

Instantly share code, notes, and snippets.

@dallinskinner

dallinskinner/search_blocks.sh

Last active July 7, 2017 20:25
Show Gist options
  • Save dallinskinner/50a17b27bb30e29b84634b6443e1de93 to your computer and use it in GitHub Desktop.
Save dallinskinner/50a17b27bb30e29b84634b6443e1de93 to your computer and use it in GitHub Desktop.
Download ZIP
Search content of blocks
Raw
search_blocks.sh
#!/bin/bash
ssh vm 'mysql '$1'_drupal -e "SELECT bid, info, CONCAT('\''https://dallin.office.lucid'$1'.com/pages/admin/structure/block/manage/block/'\'', bid, '\''/configure'\'') as url FROM block_custom WHERE body LIKE '\''%'$2'%'\''\G"'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment