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, Dec 07 '10 at 19:28
Ref: http://stackoverflow.com/questions/986826/how-to-do-a-regular-expression-replace-in-mysql — Orbling, Dec 07 '10 at 19:29

score 0 · Answer 1 · answered Dec 07 '10 at 19:25

0

Try this:

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

Your example on Rubular.

answered Dec 07 '10 at 19:25

detunized

15,059
3
48
64

Thanks, but my issue isn't finding the string so much as doing something with that string. – Nate Dec 07 '10 at 20:13
What would you like to do with it? – detunized Dec 07 '10 at 20:16

score 0 · Accepted Answer · answered Dec 29 '10 at 21:54

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 '10 at 21:54

Nate

2,035
8
23
33

Find the position of a regex substring in mysql

2 Answers2

Linked