Question : I’m using an sqlite database to store manually created labels for some data automatically queried from a live […]
Tag: regex
Oracle index with REGEXP_REPLACE is it a good idea?
Question : I have a table of contacts with 1 million registers and now the user wants to search in […]
Renaming all occurances of an HTML class name inside a table with SQL
Question : In a MYSQL database of a CMS all occurances of a specific HTML class name should be pre-fixed. […]
REGEXP_SUBSTR equivalent in MSSQL
Question : I migrate from Oracle DB to Postgres/MS-SQL and I want to use REGEXP_SUBSTR equivalent with these databases. I […]
Date pattern regex doesn’t match the records in PostgreSQL query?
Question : I am working with a dataset in PostgreSQL which is quick messy. I have written a few regex […]
How To Exclude Queries Returned From mysqldumpslow Command
Question : I would like to ignore queries in the mysql-slow log that originate from running the command mysqldumpslow by […]
SQL regex PostgreSQL
Question : Let’s consider a table like that: id | name 1 | This is a test sentence 2 | […]
Oracle regexp_like square brackets inside character set
Question : This questions is in regards to Oracle, pl/sql, and the regexp_like function. I am trying to build a […]
Oracle: REGEXP_LIKE: Strings with angle brackets aren’t found (whether they are escaped or not)
Question : The following question will answer my original question, plus many others. What would the correct syntax be to […]
Look for a list of specific characters using RegEx
Question : I’m trying to write a query (Postgres 8.2.15) which is checking whether the value in column1 consists of: […]