.NET Regex Tester - Regex Storm

Home
Tester
Reference
About

Pattern

Input

update test_table set text = :p1 where text = 'jana:klara' or some_value = :value or info = 'two'

update test_table set text =:p1 where text = 'jana:klara' or some_value =:value or info = 'two'

Options

Ignore Case

Ignore Whitespace

Explicit Capture

Culture Invariant

Singleline

Multiline

Right To Left

ECMA Script

Start from position:

Max matches to find:

Replacement

Replace matches with...

Click the context tab to see replacements.

Regex Info
Table
Context
Split List

2 matches found in about 4 milliseconds.

Show Permalink

Permalink

Index	Position	Matched String	Replacement
0	51	:	@
1	151	:	@

update test_table set text = :p1 where text = 'jana@klara' or some_value = :value or info = 'two'

update test_table set text =:p1 where text = 'jana@klara' or some_value =:value or info = 'two'

update test_table set text = :p1 where text = 'jana
klara' or some_value = :value or info = 'two'

update test_table set text =:p1 where text = 'jana
klara' or some_value =:value or info = 'two'