Regex tester
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
Replacement
Click the context tab to see replacements.
4 matches found in about 1 millisecond.
IndexPositionMatched StringReplacement
029:@
175:@
2129:@
3174:@
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'
  1. update test_table set text =
  2. p1 where text = 'jana:klara' or some_value =
  3. value or info = 'two'

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