mysql regular expression search string with numeric dash

Question

please help write a regular expression to for the following strings.

I have in database the following values

results.dr_phil_app_progress._tapes.data.exercise-1
results.dr_phil_app_progress._tapes.data.exercise-1-1
results.dr_phil_app_progress._tapes.data.exercise-2
results.dr_phil_app_progress._tapes.data.exercise-2-1
results.dr_phil_app_progress._tapes.data.exercise-2-2
results.dr_phil_app_progress._tapes.data.exercise-2-3
results.dr_phil_app_progress._tapes.data.exercise-3
results.dr_phil_app_progress._tapes.data.exercise-1.ans1
results.dr_phil_app_progress._tapes.data.exercise-1-1.ans1
results.dr_phil_app_progress._tapes.data.exercise-2.ans1
results.dr_phil_app_progress._tapes.data.exercise-2.ans2

I want to pull only the following records:

results.dr_phil_app_progress._tapes.data.exercise-1
results.dr_phil_app_progress._tapes.data.exercise-1-1
results.dr_phil_app_progress._tapes.data.exercise-2
results.dr_phil_app_progress._tapes.data.exercise-2-1
results.dr_phil_app_progress._tapes.data.exercise-2-2
results.dr_phil_app_progress._tapes.data.exercise-2-3
results.dr_phil_app_progress._tapes.data.exercise-3

I use

^results.dr_phil_app_progress._tapes.data.exercise-([0-9]|[1-9][0-9])$

that pull me

results.dr_phil_app_progress._tapes.data.exercise-1
results.dr_phil_app_progress._tapes.data.exercise-2
results.dr_phil_app_progress._tapes.data.exercise-3

How to change the expression to pull the desired result ?

EDIT

one additional case:

need reg expression for

results.dr_phil_app_progress._tapes.data.exercise-1
results.dr_phil_app_progress._tapes.data.exercise-1-1.id
results.dr_phil_app_progress._tapes.data.exercise-2.text
results.dr_phil_app_progress._tapes.data.exercise-3-1
results.dr_phil_app_progress._tapes.data.person-1
results.dr_phil_app_progress._tapes.data.person-1-1
results.dr_phil_app_progress._tapes.data.person-2

the result should be

results.dr_phil_app_progress._tapes.data.exercise-1
results.dr_phil_app_progress._tapes.data.exercise-3-1
results.dr_phil_app_progress._tapes.data.person-1
results.dr_phil_app_progress._tapes.data.person-1-1
results.dr_phil_app_progress._tapes.data.person-2

Ashkan Mobayen Khiabani · Accepted Answer · 2016-03-22 09:24:55Z

1

^results.dr_phil_app_progress._tapes.data.exercise-([0-9-]*)$

Here is the working EXAMPLE

answered Mar 22, 2016 at 9:24

Ashkan Mobayen Khiabani

34.3k35 gold badges111 silver badges187 bronze badges

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

Comments

Avinash Raj · Accepted Answer · 2016-03-22 09:22:40Z

1

You forget the hyphen and also you should escape the dots.,

"^results\\.dr_phil_app_progress\\._tapes\\.data\\.exercise-([0-9]|[1-9]-[0-9])$"

answered Mar 22, 2016 at 9:22

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

3 Comments

Ashkan Mobayen Khiabani Over a year ago

this will only match one or two part numbers. and the numbrs must be 1 digit only to match

Dumitru Gutu Over a year ago

how to match, let say: exercise-1034-678

Avinash Raj Over a year ago

exercise-([0-9]+|[1-9]+-[0-9]+)$

Rick James · Accepted Answer · 2016-03-22 23:31:53Z

0

NOT REGEXP '[.]ans'

That should work on the set you provided. If that is not good enough for the entire list, then be more precise.

answered Mar 22, 2016 at 23:31

Rick James

144k15 gold badges144 silver badges255 bronze badges

Collectives™ on Stack Overflow

mysql regular expression search string with numeric dash

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related