Delete WordPress Transients by Prefix

wp-delete-transients-by-prefix.php

<?php

/**
 * Deletes transients that match a specific prefix.
 *
 * @author Pablo Pacheco <pablo.sg.pacheco@gmail.com>
 * @param  string $prefix prefix to search for.
 * @return int|bool Boolean true for CREATE, ALTER, TRUNCATE and DROP queries. Number of rows affected/selected for all other queries. Boolean false on error.
 */
function delete_transients_by_prefix($prefix){
	global $wpdb;
	$sql = "delete from wp_options where option_name REGEXP %s";
	return $wpdb->query( $wpdb->prepare( $sql, '^_transient_' . $prefix ) );
}