regex101: JavaScript Match Workspace

Regular Expression

(uid.+[~])?~

New

CREATE TABLE IF NOT EXISTS `phpshop_foto` (`id` int(11) NOT NULL auto_increment,`parent` int(11) NOT NULL default '0',`name` varchar(64) NOT NULL default '',`num` tinyint(11) NOT NULL default '0',`info` varchar(255) NOT NULL default '',PRIMARY KEY  (`id`),KEY `parent` (`parent`)) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SELECT @currencyID := id from `phpshop_valuta` where iso="RUR";
INSERT INTO `phpshop_products` SET
pic_small="/UserFiles/Image/Items6/196-0815-4-BLK_1s.jpg",
pic_big="/UserFiles/Image/Items6/196-0815-4-BLK_1.jpg",
uid="196-0815-4-BLK",
name="Сумка Poshete black кожа муж_Y",
baseinputvaluta=@currencyID,
category="14";
SET @productID := LAST_INSERT_ID();
INSERT INTO `phpshop_foto` SET
parent=@productID,
name="/UserFiles/Image/Items6/196-0815-4-BLK_1.jpg";
INSERT INTO `phpshop_foto` SET
parent=@productID,
name="/UserFiles/Image/Items6/196-0815-4-BLK_2.jpg";
INSERT INTO `phpshop_foto` SET
parent=@productID,
name="/UserFiles/Image/Items6/196-0815-4-BLK_3.jpg";
INSERT INTO `phps

Extraction

CREATE TABLE IF NOT EXISTS `phpshop_foto` (`id` int(11) NOT NULL auto_increment,`parent` int(11) NOT NULL default '0',`name` varchar(64) NOT NULL default '',`num` tinyint(11) NOT NULL default '0',`info` varchar(255) NOT NULL default '',PRIMARY KEY  (`id`),KEY `parent` (`parent`)) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
SELECT @currencyID := id from `phpshop_valuta` where iso="RUR";
INSERT INTO `phpshop_products` SET
pic_small="/UserFiles/Image/Items6/196-0815-4-BLK_1s.jpg",
pic_big="/UserFiles/Image/Items6/196-0815-4-BLK_1.jpg",
uid="196-0815-4-BLK",
name="Сумка Poshete black кожа муж_Y",
baseinputvaluta=@currencyID,
category="14";
SET @productID := LAST_INSERT_ID();
INSERT INTO `phpshop_foto` SET
parent=@productID,
name="/UserFiles/Image/Items6/196-0815-4-BLK_1.jpg";
INSERT INTO `phpshop_foto` SET
parent=@productID,
name="/UserFiles/Image/Items6/196-0815-4-BLK_2.jpg";
INSERT INTO `phpshop_foto` SET
parent=@productID,
name="/UserFiles/Image/Items6/196-0815-4-BLK_3.jpg";
INSERT INTO `phps