Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
REGEX extraction in MySQL?
#1
table1.vals
$100.43
20
20,123
4,128.43

I want to return everything that's either digits or dots. That is, ([0-9]|\.)

It seems that the built-in REGEX function only returns whether a pattern is matched; it doesn't do extraction.

Can this be done?

Thanks!

Greg
Reply


Messages In This Thread
REGEX extraction in MySQL? - by Greg - 11-30-2009, 09:51 PM
Re: REGEX extraction in MySQL? - by Seacrest - 11-30-2009, 11:53 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)