How do I select a regex match from a text/varchar in MS SQL?
I need to extract something from a long piece of text across lots of db rows, in a Microsoft SQL Server database.
I could write a script to loop through and extract it, but I was hoping there was nice simple way I can do some SQL like:
SELECT IpAddress = matchFirst('RegEx',ColName) FROM table WHERE conditions
I’ve looked about but all I’m finding is unclear long-winded ramblings about using regex in the where clause and CLR UDFs and stuff – but all I want is a simple “insert regex here” answer.