Regular Expressions 101

Save & Share

  • Regex Version: ver. 3
  • 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

/
/
xs

Test String

Code Generator

Language

Generated Code

const regex = / (?si) ^ \s* UPDATE \s+ `mytable` \s+ SET \s+ `keyname` \s* = \s* 'keyvalue' (?# one or more such key = value ) (?> \s* , \s* (?# field name ) ` [A-Z_]+ ` (?# equals ) \s* = \s* (?# value ) (?> (?# an integer, possibly negative ) -? [0-9]+ | (?# or, a string ) ' [^'\\]* (?: (?: \\ . | '' ) [^'\\]* )* ' # ' # (?: [^'\\] | '' | \\ . )* # ' | (?# or, literal NULL ) NULL ) )+ \s+ WHERE \s+ `keyname` \s* = \s* 'keyvalue' $/s; // Alternative syntax using RegExp constructor // const regex = new RegExp(' (?si) ^ \\s* UPDATE \\s+ `mytable` \\s+ SET \\s+ `keyname` \\s* = \\s* \'keyvalue\' (?# one or more such key = value ) (?> \\s* , \\s* (?# field name ) ` [A-Z_]+ ` (?# equals ) \\s* = \\s* (?# value ) (?> (?# an integer, possibly negative ) -? [0-9]+ | (?# or, a string ) \' [^\'\\\\]* (?: (?: \\\\ . | \'\' ) [^\'\\\\]* )* \' # \' # (?: [^\'\\\\] | \'\' | \\\\ . )* # \' | (?# or, literal NULL ) NULL ) )+ \\s+ WHERE \\s+ `keyname` \\s* = \\s* \'keyvalue\' $', 's') const str = `UPDATE \`mytable\` SET \`keyname\` = 'keyvalue', \`Markup\` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. ''Quisque vel mattis odio, quis iaculis sem.'' Nulla facilisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n\\r\\n \\'Aenean in augue a est vulputate accumsan.\\' Phasellus nulla diam, laoreet a elit non, mattis finibus magna. Phasellus faucibus iaculis mi sed pulvinar.\\r\\n Aliquam non nisl ultricies, aliquam augue vitae, efficitur sapien. Etiam viverra, magna a laoreet sollicitudin, ipsum erat tincidunt sem, nec faucibus enim tortor eget massa.Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n\\r\\n \\'Aenean in augue a est vulputate accumsan.\\' Phasellus nulla diam, laoreet a elit non, mattis finibus magna. Phasellus faucibus iaculis mi sed pulvinar.\\r\\n Aliquam non nisl ultricies, aliquam augue vitae, efficitur sapien. Etiam viverra, magna a laoreet sollicitudin, ipsum erat tincidunt sem, nec faucibus enim tortor eget massa.Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n\\r\\n \\'Aenean in augue a est vulputate accumsan.\\' Phasellus nulla diam, laoreet a elit non, mattis finibus magna. Phasellus faucibus iaculis mi sed pulvinar.\\r\\n Aliquam non nisl ultricies, aliquam augue vitae, efficitur sapien. Etiam viverra, magna a laoreet sollicitudin, ipsum erat tincidunt sem, nec faucibus enim tortor eget massa.Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n\\r\\n \\'Aenean in augue a est vulputate accumsan.\\' Phasellus nulla diam, laoreet a elit non, mattis finibus magna. Phasellus faucibus iaculis mi sed pulvinar.\\r\\n Aliquam non nisl ultricies, aliquam augue vitae, efficitur sapien. Etiam viverra, magna a laoreet sollicitudin, ipsum erat tincidunt sem, nec faucibus enim tortor eget massa.Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n\\r\\n \\'Aenean in augue a est vulputate accumsan.\\' Phasellus nulla diam, laoreet a elit non, mattis finibus magna. Phasellus faucibus iaculis mi sed pulvinar.\\r\\n Aliquam non nisl ultricies, aliquam augue vitae, efficitur sapien. Etiam viverra, magna a laoreet sollicitudin, ipsum erat tincidunt sem, nec faucibus enim tortor eget massa.Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Fusce ut dui venenatis, maximus lorem eget, ornare ex. Aenean tempus pulvinar est, id fringilla enim sagittis id. Mauris finibus cursus commodo.\\r\\n\\r\\n\\r\\n \\'Aenean in augue a est vulputate accumsan.\\' Phasellus nulla diam, laoreet a elit non, mattis finibus magna. Phasellus faucibus iaculis mi sed pulvinar.\\r\\n Aliquam non nisl ultricies, aliquam augue vitae, efficitur sapien. Etiam viverra, magna a laoreet sollicitudin, ipsum erat tincidunt sem, nec faucibus enim tortor eget massa. Nunc nisi orci, lacinia vitae dictum et, vestibulum sed metus. ', \`From_Date\` = NULL, \`To_Date\` = NULL, \`Foo\` = '', \`Box_Colour\` = NULL, \`Modification_Date\` = '2016-09-08 12:30:47', \`Modified_User\` = 1, \`Modified_IP\` = '192.168.1.1' WHERE \`keyname\` = 'keyvalue'`; // Reset `lastIndex` if this regex is defined globally // regex.lastIndex = 0; 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