Regular expression - match strings between range

Question

I have a string which looks like this:

UPDATE id = :id, password = :password;

I want to match this string:

id = :id, password = :password

I wrote this regexp:

UPDATE\s(\S+\s*=\s*\S+)\s

but it matches only

id = :id,

I tried also this regexp:

UPDATE\s(\S+\s*=\s*\S+)\s;

but it cannot recognize a range what I want to match

How I have to define range in the right way to match that what I want?

I will be grateful for any advice.

I want to match whole string which looks like this "value = :value, test=:value2" from any string, spaces must be allowed. — dtx
– dtx, Commented Aug 19, 2016 at 6:17

revo · Accepted Answer · 2016-08-18 19:14:34Z

1

If input string is always a similar UPDATE statement:

UPDATE\s*\K|([^;]+)

Live demo

answered Aug 18, 2016 at 19:14

revo

49k15 gold badges84 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

dtx Over a year ago

What if I want to match: " value = :value, test=:value2" from this string: "INSERT INTO table (value, value1) VALUES (:value1, :value2,) ON DUPLICATE KEY UPDATE value = :value, test=:value2;" ?

dtx Over a year ago

I figured out how to make this. This regexp resolve my problem: UPDATE\s(.+,*?);

revo Over a year ago

Just remove the alternation UPDATE\s*\K([^;]+) @MateuszRavage

Collectives™ on Stack Overflow

Regular expression - match strings between range

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related