#!/bin/bash for i in $(mysql -e 'SHOW DATABASES;' | grep -v ^Database) do mysql -e 'USE '$i'; DELETE FROM `wp_posts` WHERE `post_author` NOT LIKE "1";' done