Regular Expressions 101

Save & Share

  • Save new Regex
    ctrl+s
  • Update 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
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
  • Match everything enclosed
    (?:...)
  • Capture everything enclosed
    (...)
  • 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

const regex = /(uid.+[~])?~/; // Alternative syntax using RegExp constructor // const regex = new RegExp('(uid.+[~])?~', '') const 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; 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 \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-0815-4-BLK_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-0815-4-BLK_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-0815-4-BLK_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-0815-4-BLK_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-0815-4~BLK_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-0815-4-BLK_9.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/196-1108-7-DBW_1s.jpg", pic_big="/UserFiles/Image/Items6/196-1108-7-DBW_1.jpg", uid="196-1108-7~DBW", name="Планшет Poshete d.brown кожа муж ipad_Y", baseinputvaluta=@currencyID, category="14"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1108-7-DBW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1108-7-DBW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1108-7-DBW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1108-7-DBW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1108-7-DBW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1108-7-DBW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1108-7-DBW_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1108-7-DBW_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1108-7-DBW_9.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/196-1126-7-DBW_1s.jpg", pic_big="/UserFiles/Image/Items6/196-1126-7-DBW_1.jpg", uid="196-1126-7-DBW", name="Сумка Poshete d.brown кожа муж ноут_Y", baseinputvaluta=@currencyID, category="20"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_9.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1126-7-DBW_10.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/196-1136-6-DBW_1s.jpg", pic_big="/UserFiles/Image/Items6/196-1136-6-DBW_1.jpg", uid="196-1136-6-DBW", name="Рюкзак Poshete d.brown кожа молод ipad_Y", baseinputvaluta=@currencyID, category="15"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1136-6-DBW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1136-6-DBW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1136-6-DBW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1136-6-DBW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1136-6-DBW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1136-6-DBW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1136-6-DBW_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1136-6-DBW_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1136-6-DBW_9.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/196-1265-3-DBW_1s.jpg", pic_big="/UserFiles/Image/Items6/196-1265-3-DBW_1.jpg", uid="196-1265-3-DBW", name="Планшет Poshete d.brown кожа HH47 A4_Y", baseinputvaluta=@currencyID, category="14"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1265-3-DBW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1265-3-DBW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1265-3-DBW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1265-3-DBW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1265-3-DBW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1265-3-DBW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1265-3-DBW_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1265-3-DBW_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1265-3-DBW_9.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/196-1640-YB42-DBW_1s.jpg", pic_big="/UserFiles/Image/Items6/196-1640-YB42-DBW_1.jpg", uid="196-1640-YB42-DBW", name="Планшет Poshete d.brown кож YB42 муж 3_Y", baseinputvaluta=@currencyID, category="14"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1640-YB42-DBW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1640-YB42-DBW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1640-YB42-DBW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1640-YB42-DBW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1640-YB42-DBW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1640-YB42-DBW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-1640-YB42-DBW_7.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/196-2712-YB42-DBW_1s.jpg", pic_big="/UserFiles/Image/Items6/196-2712-YB42-DBW_1.jpg", uid="196-2712-YB42-DBW", name="Планшет Poshete d.brown кожа YB42 муж_Y", baseinputvaluta=@currencyID, category="14"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-2712-YB42-DBW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-2712-YB42-DBW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-2712-YB42-DBW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-2712-YB42-DBW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-2712-YB42-DBW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-2712-YB42-DBW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-2712-YB42-DBW_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-2712-YB42-DBW_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-2712-YB42-DBW_9.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/196-962A-6-BRW_1s.jpg", pic_big="/UserFiles/Image/Items6/196-962A-6-BRW_1.jpg", uid="196-962A-6-BRW", name="Планшет Poshete brown кожа муж ipad_Y", baseinputvaluta=@currencyID, category="14"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-962A-6-BRW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-962A-6-BRW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-962A-6-BRW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-962A-6-BRW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-962A-6-BRW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-962A-6-BRW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-962A-6-BRW_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-962A-6-BRW_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-962A-6-BRW_9.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/196-963-6-DBW_1s.jpg", pic_big="/UserFiles/Image/Items6/196-963-6-DBW_1.jpg", uid="196-963-6-DBW", name="Планшет Poshete d.brown кожа муж A4_Y", baseinputvaluta=@currencyID, category="14"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-963-6-DBW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-963-6-DBW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-963-6-DBW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-963-6-DBW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-963-6-DBW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-963-6-DBW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-963-6-DBW_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-963-6-DBW_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/196-963-6-DBW_9.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/513-5432-024-BRR_1s.jpg", pic_big="/UserFiles/Image/Items6/513-5432-024-BRR_1.jpg", uid="513-5432-024-BRR", name="Сумка F.Molinary brr кожа жен A024-3_Y", baseinputvaluta=@currencyID, category="3"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-5432-024-BRR_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-5432-024-BRR_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-5432-024-BRR_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-5432-024-BRR_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-5432-024-BRR_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-5432-024-BRR_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-5432-024-BRR_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-5432-024-BRR_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-5432-024-BRR_9.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/513-8790-024-BRR_1s.jpg", pic_big="/UserFiles/Image/Items6/513-8790-024-BRR_1.jpg", uid="513-8790-024-BRR", name="Планшет F.Molinary brr кож жен A024-3_Y", baseinputvaluta=@currencyID, category="3"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_9.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-8790-024-BRR_10.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/513-9105-2-053-DBW_1s.jpg", pic_big="/UserFiles/Image/Items6/513-9105-2-053-DBW_1.jpg", uid="513-9105-2-053-DBW", name="Сумк F.Molin dbw кож муж ноутА4 A053-1_Y", baseinputvaluta=@currencyID, category="20"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_7.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_8.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_9.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/513-9105-2-053-DBW_10.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/519-983-F466-BLK_1s.jpg", pic_big="/UserFiles/Image/Items6/519-983-F466-BLK_1.jpg", uid="519-983-F466-BLK", name="Кошелек P.Avanti black и.к бол жен_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BLK_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BLK_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BLK_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BLK_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BLK_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BLK_6.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/519-983-F466-BRW_1s.jpg", pic_big="/UserFiles/Image/Items6/519-983-F466-BRW_1.jpg", uid="519-983-F466-BRW", name="Кошелек P.Avanti brown и.к бол жен_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BRW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BRW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BRW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BRW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BRW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BRW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-BRW_7.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/519-983-F466-RED_1s.jpg", pic_big="/UserFiles/Image/Items6/519-983-F466-RED_1.jpg", uid="519-983-F466-RED", name="Кошелек P.Avanti red и.к бол жен_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-RED_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-RED_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-RED_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-RED_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-RED_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-983-F466-RED_6.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/814-Q156-FKS_1s.jpg", pic_big="/UserFiles/Image/Items6/814-Q156-FKS_1.jpg", uid="814-Q156-FKS", name="Визитница Poshete fuksia кожа верт_Y", baseinputvaluta=@currencyID, category="48"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q156-FKS_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q156-FKS_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q156-FKS_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q156-FKS_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q156-FKS_5.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/814-Q501-FKS_1s.jpg", pic_big="/UserFiles/Image/Items6/814-Q501-FKS_1.jpg", uid="814-Q501-FKS", name="Обложка д/пасп Poshete fuksia кожа_Y", baseinputvaluta=@currencyID, category="47"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q501-FKS_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q501-FKS_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q501-FKS_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q501-FKS_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/814-Q501-FKS_5.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/903-307-18A-RED_1s.jpg", pic_big="/UserFiles/Image/Items6/903-307-18A-RED_1.jpg", uid="903-307-18A-RED", name="Кошелек P.Avanti red и.к кожа жен бол_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18A-RED_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18A-RED_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18A-RED_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18A-RED_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18A-RED_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18A-RED_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18A-RED_7.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/903-307-18F-BRW_1s.jpg", pic_big="/UserFiles/Image/Items6/903-307-18F-BRW_1.jpg", uid="903-307-18F-BRW", name="Кошелек P.Avanti brown и.к кож жен бол_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18F-BRW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18F-BRW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18F-BRW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18F-BRW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18F-BRW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18F-BRW_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18F-BRW_7.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/903-307-18K-BLK_1s.jpg", pic_big="/UserFiles/Image/Items6/903-307-18K-BLK_1.jpg", uid="903-307-18K-BLK", name="Кошелек P.Avanti black и.к кож жен бол_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18K-BLK_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18K-BLK_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18K-BLK_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18K-BLK_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18K-BLK_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18K-BLK_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/903-307-18K-BLK_7.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/847-X8043-1-RED_1s.jpg", pic_big="/UserFiles/Image/Items6/847-X8043-1-RED_1.jpg", uid="847-X8043-1-RED", name="Кошелек P.Avanti red и.к жен бол_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-RED_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-RED_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-RED_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-RED_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-RED_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-RED_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-RED_7.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/847-X8043-1-YLW_1s.jpg", pic_big="/UserFiles/Image/Items6/847-X8043-1-YLW_1.jpg", uid="847-X8043-1-YLW", name="Кошелек P.Avanti yellow и.к жен бол_N", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-YLW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-YLW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-YLW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-YLW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-YLW_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8043-1-YLW_6.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/847-X8068-RED_1s.jpg", pic_big="/UserFiles/Image/Items6/847-X8068-RED_1.jpg", uid="847-X8068-RED", name="Кошелек P.Avanti red и.к жен бол_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8068-RED_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8068-RED_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8068-RED_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8068-RED_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8068-RED_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8068-RED_6.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/847-X8328-BLK_1s.jpg", pic_big="/UserFiles/Image/Items6/847-X8328-BLK_1.jpg", uid="847-X8328-BLK", name="Кошелек P.Avanti blk и.к крок жен бол_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-BLK_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-BLK_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-BLK_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-BLK_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-BLK_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-BLK_6.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/847-X8328-RED_1s.jpg", pic_big="/UserFiles/Image/Items6/847-X8328-RED_1.jpg", uid="847-X8328-RED", name="Кошелек P.Avanti red и.к крок жен бол_Y", baseinputvaluta=@currencyID, category="46"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-RED_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-RED_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-RED_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-RED_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-RED_5.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-RED_6.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/847-X8328-RED_7.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/519-L01-88-BLK_1s.jpg", pic_big="/UserFiles/Image/Items6/519-L01-88-BLK_1.jpg", uid="519-L01-88-BLK", name="Визитница P.Avanti black и.к крок жен_Y", baseinputvaluta=@currencyID, category="48"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BLK_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BLK_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BLK_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BLK_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BLK_5.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/519-L01-88-BRW_1s.jpg", pic_big="/UserFiles/Image/Items6/519-L01-88-BRW_1.jpg", uid="519-L01-88-BRW", name="Визитница P.Avanti brown и.к крок жен_Y", baseinputvaluta=@currencyID, category="48"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BRW_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BRW_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BRW_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BRW_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-BRW_5.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/519-L01-88-RED_1s.jpg", pic_big="/UserFiles/Image/Items6/519-L01-88-RED_1.jpg", uid="519-L01-88-RED", name="Визитница P.Avanti red и.к крок жен_Y", baseinputvaluta=@currencyID, category="48"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-RED_1.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-RED_2.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-RED_3.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-RED_4.jpg"; INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/519-L01-88-RED_5.jpg"; INSERT INTO \`phpshop_products\` SET pic_small="/UserFiles/Image/Items6/939-MTS14101H-BLKs.jpg", pic_big="/UserFiles/Image/Items6/939-MTS14101H-BLK.jpg", uid="939-MTS14101H-BLK", name="Ремень F.Molinary black кожа авто муж_Y", baseinputvaluta=@currencyID, category="58"; SET @productID := LAST_INSERT_ID(); INSERT INTO \`phpshop_foto\` SET parent=@productID, name="/UserFiles/Image/Items6/939-MTS14101H-BLK.jpg"; `; let m; if ((m = regex.exec(str)) !== null) { // The result can be accessed through the `m`-variable. m.forEach((match, groupIndex) => { console.log(`Found match, group ${groupIndex}: ${match}`); }); }

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 JavaScript, please visit: https://developer.mozilla.org/en/docs/Web/JavaScript/Guide/Regular_Expressions