WordPress: Script for deleting several posts based on some conditions. (Author: Gurthg @ irc.feenode.net #wordpress)

obliterate-posts.php

<?php

add_action( 'admin_init', 'iworks_dtl' );

function iworks_dtl(){
    global $wpdb;
    $query = 'SELECT ID FROM '.$wpdb->posts.' WHERE LENGTH(post_content) < 800 AND post_type = "post" AND post_status = "publish"';
    $data = $wpdb->get_results( $query );
    foreach( $data as $one ) {
        wp_delete_post( $one->ID, true );
    }
}

?>