Regular Expressions in DB2 SQL

sql regex db2
Samer Buna picture Samer Buna · Jan 21, 2011 · Viewed 41.2k times · Source

(Other than using a UDF) Any REGEXP-In-SQL support for DB2 9.7 ?

Answer

data_henrik picture data_henrik · Jul 22, 2016

Starting with DB2 11.1 there is built-in regex support. One of the new function is REGEXP_SUBSTR and there are some more.

SELECT REGEXP_SUBSTR('hello to you', '.o',1,1) 
   FROM sysibm.sysdummy1

Related questions

Java - escape string to prevent SQL injection

I'm trying to put some anti sql injection in place in java and am finding it very difficult to work with the the "replaceAll" string function. Ultimately I need a function that will convert any existing \ to \\, any " to \", any …

Read More
How to regex in a MySQL query

I have a simple task where I need to search a record starting with string characters and a single digit after them. What I'm trying is this SELECT trecord FROM `tbl` WHERE (trecord LIKE 'ALA[d]%') And SELECT trecord …

Read More
Regular expressions inside SQL Server

I have stored values in my database that look like 5XXXXXX, where X can be any digit. In other words, I need to match incoming SQL query strings like 5349878. Does anyone have an idea how to do it? I have …

Read More