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

use strict; my $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"; '; my $regex = qr/(uid.+[~])?~/p; if ( $str =~ /$regex/ ) { print "Whole match is ${^MATCH} and its start/end positions can be obtained via \$-[0] and \$+[0]\n"; # print "Capture Group 1 is $1 and its start/end positions can be obtained via \$-[1] and \$+[1]\n"; # print "Capture Group 2 is $2 ... and so on\n"; } # ${^POSTMATCH} and ${^PREMATCH} are also available with the use of '/p' # Named capture groups can be called via $+{name}

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 Perl, please visit: http://perldoc.perl.org/perlre.html