Regular Expressions 101

@regex101
Donate
Sponsor
Contact
Bug Reports & Feedback
Wiki
Whats new?

Save & Share

  • Save Regex
    ctrl+s
  • Update Regex
    ctrl+⇧+s

Flavor

  • PCRE2 (PHP >=7.3)
  • PCRE (PHP <7.3)
  • ECMAScript (JavaScript)
  • Python 2.7
  • Golang
  • Java 8

Function

  • Match
  • Substitution
  • List
  • Unit Tests
/
^(mysqlx?:\/\/)(?:([*\w$_])(?::([+\w$_]))?@)?([*\w!#$%&'()*+,\-./;=?@[\]_~])(?::(\d{1,5}))?(?:\/[\w$_])?$
/
gm
^ asserts position at start of a line
1st Capturing Group
(mysqlx?:\/\/)
mysql matches the characters mysql literally (case sensitive)
x
matches the character x literally (case sensitive)
? matches the previous token between zero and one times, as many times as possible, giving back as needed (greedy)
: matches the character : literally (case sensitive)
\/ matches the character / literally (case sensitive)
\/ matches the character / literally (case sensitive)
Non-capturing group
(?:([*\w$_])(?::([+\w$_]))?@)?
? matches the previous token between zero and one times, as many times as possible, giving back as needed (greedy)
2nd Capturing Group
([*\w$_])
Match a single character present in the list below
[\w$_]
* matches the previous token between zero and unlimited times, as many times as possible, giving back as needed (greedy)
\w matches any word character (equivalent to [a-zA-Z0-9_])
$_ matches a single character in the list $_ (case sensitive)
Non-capturing group
(?::([+\w$_]))?
? matches the previous token between zero and one times, as many times as possible, giving back as needed (greedy)
: matches the character : literally (case sensitive)
3rd Capturing Group
([+\w$_])
@ matches the character @ literally (case sensitive)
4th Capturing Group
([*\w!#$%&'()*+,\-./;=?@[\]_~])
Match a single character present in the list below
[\w!#$%&'()*+,\-./;=?@[\]_~]
* matches the previous token between zero and unlimited times, as many times as possible, giving back as needed (greedy)
\w matches any word character (equivalent to [a-zA-Z0-9_])
!#$%&'()*+, matches a single character in the list !#$%&'()*+, (case sensitive)
\- matches the character - literally (case sensitive)
./;=?@[ matches a single character in the list ./;=?@[ (case sensitive)
\] matches the character ] literally (case sensitive)
_~ matches a single character in the list _~ (case sensitive)
Non-capturing group
(?::(\d{1,5}))?
? matches the previous token between zero and one times, as many times as possible, giving back as needed (greedy)
: matches the character : literally (case sensitive)
5th Capturing Group
(\d{1,5})
\d
matches a digit (equivalent to [0-9])
Non-capturing group
(?:\/[\w$_])?
? matches the previous token between zero and one times, as many times as possible, giving back as needed (greedy)
\/ matches the character / literally (case sensitive)
Match a single character present in the list below
[\w$_]
$ asserts position at the end of a line
Global pattern flags
g modifier: global. All matches (don't return after first match)
m modifier: multi line. Causes ^ and $ to match the begin/end of each line (not only begin/end of string)
Your regular expression does not match the subject string.

Regular Expression
No Match

/
/
gm

Test String