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

using System; using System.Text.RegularExpressions; public class Example { public static void Main() { string pattern = @"(uid.+[~])?~"; string input = @"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""; "; Match m = Regex.Match(input, pattern); Console.WriteLine("'{0}' found at index {1}", m.Value, m.Index); } }

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 C#, please visit: https://msdn.microsoft.com/en-us/library/system.text.regularexpressions.regex(v=vs.110).aspx