SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE tbl ( link text ); INSERT INTO tbl VALUES ('<p style=\"text-align:center;\"><!--dle_media_begin:https://youtu.be/Y9uj_C0oiRU--><iframe width="612" height="344" src="https://www.youtube.com/embed/Y9uj_C0oiRU?feature=oembed" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe><!--dle_media_end--></p>'); SELECT MID(LEFT(link, LOCATE('?', link, LOCATE('src="', link))-1), LOCATE('src="', link)+5) as l FROM tbl; UPDATE tbl SET link = CONCAT( '<p>[playerjs file:\"', MID(LEFT(link, LOCATE('?', link, LOCATE('src="', link))-1), LOCATE('src="', link)+5), '\"]</p>' ); SELECT * FROM tbl;