Question : Trying to pull just the Street addresses out of this data: CREATE TABLE foo(Places varchar(50)); INSERT foo(Places) VALUES […]
Tag: string-manipulation
Batch update to replace special characters in SQL Studio Management
Question : I am trying to remove/correct some special characters in my database that show strange behaviour when exported. Specifically […]
How do You concatenate a value to an array that was retrieved through a query in sql?
Question : I have a table named “mkvtable” that establishes a correspondence between individual strings and arrays of strings: word […]
Is there a better way than this to split a string and get the first substring?
Question : I’m trying to cut off everything after a certain character (in this case ‘&’) and if there is […]
How to use query result as REPLACE parameters
Question : i’m trying to: 1- Find a string inside a lot of content 2- Replace that specific part of […]
Unexpected behavior from ltrim in postgres
Question : select ltrim(‘Test Thing’, ‘Test ‘); Expected: ‘Thing’ Actual Result: ‘hing’ Why does the ‘T’ in ‘Test’ match and […]
Compare words in a string without considering their positions?
Question : In Postgres 9.6 I want to test whether two strings like these are considered the same: ‘this is […]
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 […]
Wordcount in a field (all and unique) – is there a more elegant/optimal way?
Question : Answering this question, Given this table (constructed from the question): CREATE TABLE wordcount (id SERIAL NOT NULL PRIMARY […]
Concatenate a string value from table A to a text field in table B, in a scalable way
Question : On a daily basis, I am adding values from the following table (table1): Id Name Value 1 ‘Name […]