Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: string-manipulation

Extract street address from string with multiple delimiters and positions

By adminPosted on January 4, 2023

Question : Trying to pull just the Street addresses out of this data: CREATE TABLE foo(Places varchar(50)); INSERT foo(Places) VALUES […]

Batch update to replace special characters in SQL Studio Management

By adminPosted on January 2, 2023

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?

By adminPosted on December 31, 2022

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?

By adminPosted on December 21, 2022

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

By adminPosted on October 31, 2022

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

By adminPosted on October 4, 2022

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?

By adminPosted on October 3, 2022

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

By adminPosted on September 1, 2022

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?

By adminPosted on August 1, 2022

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

By adminPosted on July 17, 2022

Question : On a daily basis, I am adding values from the following table (table1): Id Name Value 1 ‘Name […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Is it Possible to Recover Data from a BLACKHOLE table? [closed]
  • MySQL: sysbench test – InnoDB vs Memory tables
  • Why are virtual log files not always allocated in order?
  • Need help to understand how information_schema.TABLES get updated
  • unique constraint on a set
  • PostgreSQL, integer arrays, index for equality
  • What is the most performant way to group by and join high cardinality columns in column based table?
  • LOAD DATA (400k rows) INFILE takes about 7 minutes, cannot kill the “logging slow query” process?
  • Is a process created in Oracle for every SQL statement?
  • How to select a row based on the maximum value of a column, when ties are expected
  • I am unable to join tables in correct manner
  • How often to backup database and what are the favoroble practices to do so [closed]
  • In Postgresql, after pg_dump the access privileges on the database itself are not restored
  • InnoDB Buffer pool not showing as much I configured in MariaDB 10.5
  • Which version of SQL Server 2016 supports R
  • Design DB for users with different information fields?
  • WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)
  • Speeding up group by and max query
  • Adding index only on read replica of PostgreSQL RDS instance
  • Proper normalization for an Orders table–whether to split or no

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding