Question : I am trying to remove/correct some special characters in my database that show strange behaviour when exported. Specifically […]
Tag: replace
Renaming all occurances of an HTML class name inside a table with SQL
Question : In a MYSQL database of a CMS all occurances of a specific HTML class name should be pre-fixed. […]
Need to replace only first occurrence of string
Question : I hope I worded the question right. Here are the specifics: This is regarding a MySQL database. I’ve […]
Find and Replace text in all table using mysql query
Question : I have a database with name test having two tables sample1(name, quote) sample2(name, quote) I need a replace […]
How to speed up string cleanup function?
Question : I need to cleanup a string, so that certain ASCII code characters are left out of the string, […]
Replace specific part of a string
Question : I’ve got a table with multiple columns, APGRPID, VIRTKEY, LFDNR and PARAMETERLIST. I want to change a part […]
Replace all Numeric Values with Single Character
Question : I have a value in a SQL table like the below: 80400365_SwapOpenTrd_20180831.csv I want to replace the numeric […]
SQL Server: Replace with wildcards?
Question : Does Microsoft SQL Server natively support some sort of replace function using wild cards? I gather that Regular […]
Query to change all field in a given mysql table?
Question : I have a table with a timestamp field called “time”. I have many records in this table and […]
TSQL Remove Characters from Text Value
Question : I have been using the REPLACE function to remove characters from a text value in a table. It […]