query( $wpdb->prepare( "DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE %s", $wpdb->esc_like( '_refract_' ) . '%' ) ); $transients = $wpdb->get_col( $wpdb->prepare( "SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE %s", $wpdb->esc_like( '_transient_refract_' ) . '%' ) ); // phpcs:enable foreach ( $transients as $option_name ) { delete_transient( substr( (string) $option_name, strlen( '_transient_' ) ) ); } } }