Regular Expressions 101

Save & Share

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

Flavor

  • PCRE2 (PHP >=7.3)
  • PCRE (PHP <7.3)
  • ECMAScript (JavaScript)
  • Python
  • Golang
  • Java 8
  • .NET 7.0 (C#)
  • Rust
  • Regex Flavor Guide

Function

  • Match
  • Substitution
  • List
  • Unit Tests

Tools

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]
  • 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
No Match

/
/

Test String

Code Generator

Language

Generated Code

# coding=utf8 # the above tag defines encoding for this document and is for Python 2.x compatibility import re regex = 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") matches = re.search(regex, test_str) if matches: print ("Match was found at {start}-{end}: {match}".format(start = matches.start(), end = matches.end(), match = matches.group())) for groupNum in range(0, len(matches.groups())): groupNum = groupNum + 1 print ("Group {groupNum} found at {start}-{end}: {group}".format(groupNum = groupNum, start = matches.start(groupNum), end = matches.end(groupNum), group = matches.group(groupNum))) # Note: for Python 2.7 compatibility, use ur"" to prefix the regex and u"" to prefix the test string and substitution.

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