SO-43375396, MySQL

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

DROP TABLE IF EXISTS `wp_posts`;

CREATE TABLE IF NOT EXISTS `wp_posts` (
    `post_content` TEXT
);

INSERT INTO `wp_posts`
    (`post_content`)
VALUES
    ('<img src="http://example.com/img/20150823_image.jpg" style="width: 730px; height: 730px;" />'),
    ('<img src="http://example.com/img/20150824_image.jpg" style="width: 730px; height: 1500px;" />'),
    ('<img src="http://example.com/img/20150825_image.jpg" style="width: 730px; height: 80px;" />'),
    ('<img src="http://example.com/img/20150826_image.jpg" style="width: 730px; height: 0px;" />'),
    ('<img src="http://example.com/img/20150827_image.jpg" style="width: 730px;" />');

DROP FUNCTION IF EXISTS `get_string`;

CREATE FUNCTION `get_string`(`_string` TEXT,
                             `_begin` VARCHAR(255),
                             `_end` VARCHAR(255))
    RETURNS TEXT DETERMINISTIC
BEGIN
    DECLARE `_begin_pos` INT UNSIGNED DEFAULT LOCATE(`_begin`, `_string`);
    DECLARE `_end_pos` INT UNSIGNED DEFAULT 0;
    IF `_begin_pos` IS NOT NULL AND `_begin_pos` > 0 THEN
        SET `_end_pos` := LOCATE(`_end`, `_string`, `_begin_pos`);
        IF `_end_pos` IS NOT NULL AND `_end_pos` > 0 THEN
            RETURN SUBSTRING(`_string`,
                             `_begin_pos`,
                             (`_end_pos` + CHAR_LENGTH(`_end`)) - `_begin_pos`); 
        END IF;
    END IF;
    RETURN '';
END\\

SELECT `post_content`
FROM `wp_posts`;

UPDATE `wp_posts`
SET `post_content` = REPLACE(`post_content`, `get_string`(`post_content`, ' height:', ';'), '');

SELECT `post_content`
FROM `wp_posts`;

DROP TABLE IF EXISTS `wp_posts`;
DROP FUNCTION IF EXISTS `get_string`;


absolute service time: 1,25 sec