All
ActionScript

Ajax

AngularJS

Apache

AppleScript

ASP.NET

Bash

C

C#

C++

Coffee

CoffeeScript

ColdFusion

Command

CSS

Delphi

Django

ES6

GLSL

Grunt

Gulp

HAML

Haskell

HTML

iOS

Jade

Java

JavaScript

jQuery

JSX

Less

LUA

MDX

MySQL

Objective

Other

Pascal

Perl

PHP

Plain text

PowerShell

Processing

Progress

Prolog

Pseudocode

Python

Rails

RegExr

Ruby

SASS

Scala

Scheme

SCSS

SmallBASIC

Smarty

SQL

Stylus

SVG

Swift

TypeScript

VHDL

X++

XHTML

XML

Xojo

XSLT
New snippet New playground
Sign up
Login

Mass-replace a substring

MySQL
by Andrey Romanov
25th February 2016

1
2
    UPDATE   TABLE
    SET      COLUMN = REPLACE(COLUMN, search_string, replace_string)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Be the first to comment