Question : I am working with a dataset in PostgreSQL which is quick messy. I have written a few regex […]
Tag: 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: […]
Oracle: How to create secondary index based on every word in a CLOB
Question : I have a Table where each record is made up of a VARCHAR2 and a CLOB. The VARCHAR2 […]
Convert Ruby regex to Postgres regex, for selecting invalid email addresses
Question : I’ve done some internet trawling, and some reading of the Postgres regex docs, but I’m at the stage […]
Oracle regular expression replace in string ignoring first and last characters
Question : regular expression replace in string ignoring first and last characters if they matched my try SELECT REGEXP_REPLACE (‘TLYU […]
How to select any couple of digits except ’00’ using mysql regex subset syntax?
Question : I just found out that mysql doesn’t support full regular expressions syntax. I have to select any couple […]