Question : I have the following string in db: A/B/C/ A/B/D/ E/F/C/ It’s the uri column. The table is the […]
Tag: string-splitting
Select INTs from start of string separated by a character (pipe). Update other columns using these INTs
Question : In the above screen shot, the Description column has many special characters. We want before | number update […]
Performance gap between WHERE IN (1,2,3,4) vs IN (select * from STRING_SPLIT(‘1,2,3,4′,’,’))
Question : I seem to be having a huge performance gap between using hard coded values for a SELECT IN, […]
Index for split string. PostgreSQL 10
Question : I have the following string in db: A/B/C/ A/B/D/ E/F/C/ It’s the uri column. The table is the […]
MySQL: Split column by delimiter & replace numbers with values from another column
Question : Using MySQL, split column by delimiter & replace numbers with values from another column. I have a column […]
Performance gap between WHERE IN (1,2,3,4) vs IN (select * from STRING_SPLIT(‘1,2,3,4′,’,’))
Question : I seem to be having a huge performance gap between using hard coded values for a SELECT IN, […]
Split a comma-separated record into its own rows
Question : I have the following table, named stores: store_id INT emails VARCHAR That contains values: store_id emails 1 user_1@example.com,user2@example.com […]
Splitting a column on underscores [duplicate]
Question : This question already has answers here: Split String Function (2 answers) T SQL Table Valued Function to Split […]
Problems splitting and aggregating data in SQL
Question : Hello I have the following data in csv file: OrderID, OrderType, Amount, Price, Time 1, Buy, 10, 1, […]
Split hyphenated nvarchar value [duplicate]
Question : This question already has answers here: T SQL Table Valued Function to Split a Column on commas (5 […]
- 1
- 2