Regular Expressions in DB2 SQL

by

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

More Related Contents:

  1. Difference between LIKE and ~ in Postgres
  2. DB2 Comma Separated Output by Groups
  3. REGEX to select nth value from a list, allowing for nulls
  4. Does DB2 have an “insert or update” statement?
  5. how to transform comma separated column into multiples rows in db2
  6. INNER JOIN in UPDATE sql for DB2
  7. Best equivalent for IsInteger in SQL Server
  8. How to Split String by Character into Separate Columns in SQL Server
  9. oracle — Split multiple comma separated values in oracle table to multiple rows
  10. Pivoting in DB2
  11. Regular expression in PostgreSQL LIKE clause
  12. Regular expression to match common SQL syntax?
  13. Oracle 11g – Check constraint with RegEx
  14. How to resolve SQL0418N Error
  15. Perform regex (replace) in an SQL query
  16. Regular Expression to Match All Comments in a T-SQL Script
  17. DB2 Query to retrieve all table names for a given schema
  18. MSSQL Regular expression
  19. RegEx to Detect SQL Injection
  20. How to check db2 version
  21. look back in SQL
  22. Splitting string into multiple rows in Oracle
  23. SQL JOIN vs IN performance?
  24. Microsoft Jet wildcards: asterisk or percentage sign?
  25. Getting date list in a range in PostgreSQL
  26. Why is SQL server throwing this error: Cannot insert the value NULL into column ‘id’?
  27. SQL Server equivalent to MySQL enum data type?
  28. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  29. SQL – How do I get only the numbers after the decimal?
  30. How to retrieve records for last 30 minutes in MS SQL?

Leave a Comment