I have the query In Oracle SQL: select town_name, regexp_substr(town_name, '[^A,]+', 1, 1) as c1, regexp_substr(town_name, '[^A,]+', 1, 2) as c2, regexp_substr(town_name, '[^A,]+', 1, rownum...

I need to get all the matches of a regular expression in a text field in a MariaDB table. As far as I know REGEXP_SUBSTR is the way to go to get the value of the match of a regular expression in a ...

I have a database table (Oracle 11g) of questionnaire feedback, including multiple choice, multiple answer questions. The Options column has each value the user could choose, and the Answers column...

I have a column with a lot of inconsistent strings. Some of them contain a substring with a consistent pattern of '2015mmdd_AB_CD_EFG_(text)_(text)_HIJ' which I would like to extract. I feel this i...

I need to select the first X words in a string, where x can be any number from 0-100. Is there an easy way to do this? I found the following example to select the first 2 words from a string: sele...