Regular Expressions 101

Save & Share

  • Current Version: 7
  • Update Regex
    ctrl+⇧+s
  • Save new Regex
    ctrl+s
  • Add to Community Library

Flavor

  • PCRE2 (PHP)
  • ECMAScript (JavaScript)
  • Python
  • Golang
  • Java
  • .NET 7.0 (C#)
  • Rust
  • PCRE (Legacy)
  • Regex Flavor Guide

Function

  • Match
  • Substitution
  • List
  • Unit Tests
Sponsors
There are currently no sponsors. Become a sponsor today!
An explanation of your regex will be automatically generated as you type.
Detailed match information will be displayed here automatically.
  • All Tokens
  • Common Tokens
  • General Tokens
  • Anchors
  • Meta Sequences
  • Quantifiers
  • Group Constructs
  • Character Classes
  • Flags/Modifiers
  • Substitution
  • A single character of: a, b or c
    [abc]
  • A character except: a, b or c
    [^abc]
  • A character in the range: a-z
    [a-z]
  • A character not in the range: a-z
    [^a-z]
  • A character in the range: a-z or A-Z
    [a-zA-Z]
  • Character class intersection
    [\w&&[^\d]]
  • Any single character
    .
  • Alternate - match either a or b
    a|b
  • Any whitespace character
    \s
  • Any non-whitespace character
    \S
  • Any digit
    \d
  • Any non-digit
    \D
  • Any word character
    \w
  • Any non-word character
    \W
  • Non-capturing group
    (?:...)
  • Capturing group
    (...)
  • Zero or one of a
    a?
  • Zero or more of a
    a*
  • One or more of a
    a+
  • Exactly 3 of a
    a{3}
  • 3 or more of a
    a{3,}
  • Between 3 and 6 of a
    a{3,6}
  • Start of string
    ^
  • End of string
    $
  • A word boundary
    \b
  • Non-word boundary
    \B

Regular Expression
Processing...

Test String

Code Generator

Language

Generated Code

import re regex = re.compile(r"(uid.+[~])?~") test_str = ("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;\n" "SELECT @currencyID := id from `phpshop_valuta` where iso=\"RUR\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/196-0815-4-BLK_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/196-0815-4-BLK_1.jpg\",\n" "uid=\"196-0815-4-BLK\",\n" "name=\"Сумка Poshete black кожа муж_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"14\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-0815-4-BLK_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-0815-4-BLK_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-0815-4-BLK_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-0815-4-BLK_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-0815-4-BLK_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-0815-4-BLK_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-0815-4-BLK_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-0815-4~BLK_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-0815-4-BLK_9.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/196-1108-7-DBW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/196-1108-7-DBW_1.jpg\",\n" "uid=\"196-1108-7~DBW\",\n" "name=\"Планшет Poshete d.brown кожа муж ipad_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"14\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1108-7-DBW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1108-7-DBW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1108-7-DBW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1108-7-DBW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1108-7-DBW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1108-7-DBW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1108-7-DBW_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1108-7-DBW_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1108-7-DBW_9.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/196-1126-7-DBW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/196-1126-7-DBW_1.jpg\",\n" "uid=\"196-1126-7-DBW\",\n" "name=\"Сумка Poshete d.brown кожа муж ноут_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"20\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_9.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1126-7-DBW_10.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/196-1136-6-DBW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/196-1136-6-DBW_1.jpg\",\n" "uid=\"196-1136-6-DBW\",\n" "name=\"Рюкзак Poshete d.brown кожа молод ipad_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"15\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1136-6-DBW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1136-6-DBW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1136-6-DBW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1136-6-DBW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1136-6-DBW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1136-6-DBW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1136-6-DBW_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1136-6-DBW_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1136-6-DBW_9.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/196-1265-3-DBW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/196-1265-3-DBW_1.jpg\",\n" "uid=\"196-1265-3-DBW\",\n" "name=\"Планшет Poshete d.brown кожа HH47 A4_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"14\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1265-3-DBW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1265-3-DBW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1265-3-DBW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1265-3-DBW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1265-3-DBW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1265-3-DBW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1265-3-DBW_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1265-3-DBW_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1265-3-DBW_9.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/196-1640-YB42-DBW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/196-1640-YB42-DBW_1.jpg\",\n" "uid=\"196-1640-YB42-DBW\",\n" "name=\"Планшет Poshete d.brown кож YB42 муж 3_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"14\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1640-YB42-DBW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1640-YB42-DBW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1640-YB42-DBW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1640-YB42-DBW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1640-YB42-DBW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1640-YB42-DBW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-1640-YB42-DBW_7.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_1.jpg\",\n" "uid=\"196-2712-YB42-DBW\",\n" "name=\"Планшет Poshete d.brown кожа YB42 муж_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"14\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-2712-YB42-DBW_9.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/196-962A-6-BRW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/196-962A-6-BRW_1.jpg\",\n" "uid=\"196-962A-6-BRW\",\n" "name=\"Планшет Poshete brown кожа муж ipad_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"14\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-962A-6-BRW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-962A-6-BRW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-962A-6-BRW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-962A-6-BRW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-962A-6-BRW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-962A-6-BRW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-962A-6-BRW_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-962A-6-BRW_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-962A-6-BRW_9.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/196-963-6-DBW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/196-963-6-DBW_1.jpg\",\n" "uid=\"196-963-6-DBW\",\n" "name=\"Планшет Poshete d.brown кожа муж A4_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"14\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-963-6-DBW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-963-6-DBW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-963-6-DBW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-963-6-DBW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-963-6-DBW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-963-6-DBW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-963-6-DBW_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-963-6-DBW_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/196-963-6-DBW_9.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/513-5432-024-BRR_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/513-5432-024-BRR_1.jpg\",\n" "uid=\"513-5432-024-BRR\",\n" "name=\"Сумка F.Molinary brr кожа жен A024-3_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"3\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-5432-024-BRR_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-5432-024-BRR_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-5432-024-BRR_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-5432-024-BRR_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-5432-024-BRR_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-5432-024-BRR_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-5432-024-BRR_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-5432-024-BRR_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-5432-024-BRR_9.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/513-8790-024-BRR_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/513-8790-024-BRR_1.jpg\",\n" "uid=\"513-8790-024-BRR\",\n" "name=\"Планшет F.Molinary brr кож жен A024-3_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"3\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_9.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-8790-024-BRR_10.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_1.jpg\",\n" "uid=\"513-9105-2-053-DBW\",\n" "name=\"Сумк F.Molin dbw кож муж ноутА4 A053-1_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"20\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_7.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_8.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_9.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/513-9105-2-053-DBW_10.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/519-983-F466-BLK_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/519-983-F466-BLK_1.jpg\",\n" "uid=\"519-983-F466-BLK\",\n" "name=\"Кошелек P.Avanti black и.к бол жен_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BLK_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BLK_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BLK_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BLK_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BLK_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BLK_6.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/519-983-F466-BRW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/519-983-F466-BRW_1.jpg\",\n" "uid=\"519-983-F466-BRW\",\n" "name=\"Кошелек P.Avanti brown и.к бол жен_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BRW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BRW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BRW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BRW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BRW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BRW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-BRW_7.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/519-983-F466-RED_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/519-983-F466-RED_1.jpg\",\n" "uid=\"519-983-F466-RED\",\n" "name=\"Кошелек P.Avanti red и.к бол жен_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-RED_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-RED_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-RED_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-RED_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-RED_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-983-F466-RED_6.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/814-Q156-FKS_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/814-Q156-FKS_1.jpg\",\n" "uid=\"814-Q156-FKS\",\n" "name=\"Визитница Poshete fuksia кожа верт_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"48\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q156-FKS_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q156-FKS_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q156-FKS_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q156-FKS_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q156-FKS_5.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/814-Q501-FKS_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/814-Q501-FKS_1.jpg\",\n" "uid=\"814-Q501-FKS\",\n" "name=\"Обложка д/пасп Poshete fuksia кожа_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"47\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q501-FKS_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q501-FKS_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q501-FKS_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q501-FKS_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/814-Q501-FKS_5.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/903-307-18A-RED_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/903-307-18A-RED_1.jpg\",\n" "uid=\"903-307-18A-RED\",\n" "name=\"Кошелек P.Avanti red и.к кожа жен бол_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18A-RED_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18A-RED_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18A-RED_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18A-RED_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18A-RED_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18A-RED_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18A-RED_7.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/903-307-18F-BRW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/903-307-18F-BRW_1.jpg\",\n" "uid=\"903-307-18F-BRW\",\n" "name=\"Кошелек P.Avanti brown и.к кож жен бол_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18F-BRW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18F-BRW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18F-BRW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18F-BRW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18F-BRW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18F-BRW_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18F-BRW_7.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/903-307-18K-BLK_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/903-307-18K-BLK_1.jpg\",\n" "uid=\"903-307-18K-BLK\",\n" "name=\"Кошелек P.Avanti black и.к кож жен бол_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18K-BLK_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18K-BLK_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18K-BLK_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18K-BLK_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18K-BLK_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18K-BLK_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/903-307-18K-BLK_7.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/847-X8043-1-RED_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/847-X8043-1-RED_1.jpg\",\n" "uid=\"847-X8043-1-RED\",\n" "name=\"Кошелек P.Avanti red и.к жен бол_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-RED_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-RED_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-RED_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-RED_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-RED_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-RED_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-RED_7.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/847-X8043-1-YLW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/847-X8043-1-YLW_1.jpg\",\n" "uid=\"847-X8043-1-YLW\",\n" "name=\"Кошелек P.Avanti yellow и.к жен бол_N\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-YLW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-YLW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-YLW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-YLW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-YLW_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8043-1-YLW_6.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/847-X8068-RED_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/847-X8068-RED_1.jpg\",\n" "uid=\"847-X8068-RED\",\n" "name=\"Кошелек P.Avanti red и.к жен бол_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8068-RED_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8068-RED_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8068-RED_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8068-RED_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8068-RED_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8068-RED_6.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/847-X8328-BLK_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/847-X8328-BLK_1.jpg\",\n" "uid=\"847-X8328-BLK\",\n" "name=\"Кошелек P.Avanti blk и.к крок жен бол_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-BLK_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-BLK_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-BLK_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-BLK_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-BLK_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-BLK_6.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/847-X8328-RED_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/847-X8328-RED_1.jpg\",\n" "uid=\"847-X8328-RED\",\n" "name=\"Кошелек P.Avanti red и.к крок жен бол_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"46\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-RED_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-RED_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-RED_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-RED_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-RED_5.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-RED_6.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/847-X8328-RED_7.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/519-L01-88-BLK_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/519-L01-88-BLK_1.jpg\",\n" "uid=\"519-L01-88-BLK\",\n" "name=\"Визитница P.Avanti black и.к крок жен_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"48\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BLK_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BLK_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BLK_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BLK_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BLK_5.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/519-L01-88-BRW_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/519-L01-88-BRW_1.jpg\",\n" "uid=\"519-L01-88-BRW\",\n" "name=\"Визитница P.Avanti brown и.к крок жен_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"48\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BRW_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BRW_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BRW_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BRW_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-BRW_5.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/519-L01-88-RED_1s.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/519-L01-88-RED_1.jpg\",\n" "uid=\"519-L01-88-RED\",\n" "name=\"Визитница P.Avanti red и.к крок жен_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"48\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-RED_1.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-RED_2.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-RED_3.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-RED_4.jpg\";\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/519-L01-88-RED_5.jpg\";\n" "INSERT INTO `phpshop_products` SET\n" "pic_small=\"/UserFiles/Image/Items6/939-MTS14101H-BLKs.jpg\",\n" "pic_big=\"/UserFiles/Image/Items6/939-MTS14101H-BLK.jpg\",\n" "uid=\"939-MTS14101H-BLK\",\n" "name=\"Ремень F.Molinary black кожа авто муж_Y\",\n" "baseinputvaluta=@currencyID,\n" "category=\"58\";\n" "SET @productID := LAST_INSERT_ID();\n" "INSERT INTO `phpshop_foto` SET\n" "parent=@productID,\n" "name=\"/UserFiles/Image/Items6/939-MTS14101H-BLK.jpg\";\n") match = regex.search(test_str) if match: print(f"Match was found at {match.start()}-{match.end()}: {match.group()}") for group_num, group in enumerate(match.groups(), start=1): print(f"Group {group_num} found at {match.start(group_num)}-{match.end(group_num)}: {group}")

Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for Python, please visit: https://docs.python.org/3/library/re.html