Month: May 2018

SQL substring replacement

Naveen Nayak May 14, 2018 No Comments MySQL, Tips and Tricks

There are times when you need to replace only a part of the string in the database column. You can use the stuff() function in MSSQL or insert() function in MySQL MSSQL Definition: STUFF ( string , start , length , replaceWith ) Example: select stuff(‘My Original String’, 4, 8, ‘Replaced’); Output: My Replaced String […]

Page 1 of 1