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
#2
I don't think it can be.
Maybe with a custom function or stored proc, but that might involve writing a full regex implementation, which seems like overkill.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)