Lab Sql

Requirements Single-lines comments (e.g. -- my comment) should be removed. Multi-line comments (e.… Read more Sql/regex Challenge/puzzle: How To Remove Comments From Sql Code (by Using Sql Query)?

OK, this might seem too tough to be posted here so I beg your pardon. Been working on this for almo… Read more How Do I Extract Selected Columns Given An Oracle Sql String?

I have a table, which has 2 columns: ID & JOB_Description(Text). I would like to write an oracl… Read more Oracle Get All Matched Occurrences From A Column

I'm trying to extract email addresses from an existing comments field and put it into its own c… Read more Extract Email Address From String Using Tsql

I need to extract 8 digits after a known string: | MyString | Extract: | | ---… Read more Bigquery - Regex To Match Number Of 8 Digits After A Known String

I'm trying to get a regex to capture the base URL from a URL string. This ^(.+?[^\/:])(?=[?\/]|… Read more Why Won't This Regex Work In Postgresql

I have an SQL string that looks something like this: SELECT USER.'ID', USER.'NAME&#… Read more How To Select Column Names And Tables Of An Sql Using Regex?

How can I match the whole word in mysql? For instance, if I type in 'lau', I don't want… Read more Mysql Regexp To Match The Whole Word Only