SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE banner(id INT NOT NULL AUTO_INCREMENT, banner_name VARCHAR(255), html_text TEXT, PRIMARY KEY (id)); INSERT banner VALUES (1, 'Home page banner', '<h4 class="my-class">Home page banner here</h4> <h4 class="test">Any text here</h4>'); INSERT banner(banner_name, html_text) VALUES ('Cart page banner', '<h4 class="my-class">Cart page banner here</h4> <h4 class="test">Any another text here</h4>'); UPDATE `banner` SET `html_text` = REPLACE(html_text, '</h4>', '</span>'); UPDATE `banner` SET `html_text` = REPLACE(html_text, '<h4 class', '<span class' ); SELECT*FROM banner;