Find the position of a regex substring in mysql

Question

I need to extract a few fields of data from many lines of text. The data I am looking for is always in the same format ("from #.#####.##########") but it always contains different data. I know I can use regex to determine if that pattern is met... but I know the pattern is met. I want to know where in the string the pattern is met so that I can substring it out of there. Is that possible?

So a few of the lines of text might look like...
Oh, hello there. Blah blah blah. from 1.12345.1234567890 doopeedoo whoop!
Lay tee dah good sir! from 3.98766.123487650 and some other stuff!

Thanks in advance!

As it goes, I'm not sure MySQL has a function for this, all the REGEXP commands appear to be boolean in return value. — Orbling
– Orbling, Commented Dec 7, 2010 at 19:28

detunized · Accepted Answer · 2010-12-07 19:25:02Z

0

Try this:

/from \d+\.\d+\.\d+/

Your example on Rubular.

answered Dec 7, 2010 at 19:25

detunized

15.3k3 gold badges50 silver badges66 bronze badges

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

2 Comments

Nate Over a year ago

Thanks, but my issue isn't finding the string so much as doing something with that string.

detunized Over a year ago

What would you like to do with it?

Nate · Accepted Answer · 2010-12-29 21:54:23Z

0

As Orbling noted, there doesn't seem to be a function for returning the string, only telling if it exists or not. I ended up using wild substring and index search functions.

answered Dec 29, 2010 at 21:54

Nate

2,0358 gold badges24 silver badges33 bronze badges

Collectives™ on Stack Overflow

Find the position of a regex substring in mysql

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related