Lab Sql

I have data like this 1,2,3,4-8,10,11 I want split the data into rows with these 2 rules : The , w… Read more Split Data In Sql With Multiple Delimiters ( , And - ) With Owns Rule

Very new to SQL but I require some help with something that I am sure is a simple fix. I have a sin… Read more Sql Sting Split Into Single Column

I have a Projects table with ID and Responsible manager. The Responsible manager columns has values… Read more Find Manager In A Comma-separated List

I have a database (Postgres 7.4) field for address Example Data address | zip ---… Read more Extract First Numeric Part Of Field

I have a table with a field consisting of multiple strings seperated by a '+'. Each part o… Read more Splitting A String Into Rows

I am trying to parse Twitter RSS feeds and put the information in a sqlite database, using Python. … Read more Split Twitter Rss String Using Python

I have two columns, id integer and version text. I am trying to convert the strings in version into… Read more Substituting Value In Empty Field After Using Split_part

When running this query: SELECT id,selected_placements FROM app_data.content_cards I get a ta… Read more How To Split Array Into Rows In Postgresql