Tutorials and Code

ActionScript (5)
ASP (7)
ASP.NET (28)
Assembly (1)
C (6)
C# (132)
C++ (33)
CSS (6)
General (4)
HTML (6)
Java (28)
JavaScript (38)
MySQL (2)
Objective C (1)
Pascal (1)
PHP (61)
Python (3)
Ruby (18)
Silverlight (1)
SQL (7)
VB.NET (5)
Visual Basic (3)

Syndication

My Account

Community Forums

Webmaster Tools

Tech Jobs

Geekpedia » MySQL Knowledge Base » Search and replace table field contents

Search and replace table field contents

On Thursday, September 18th 2008 at 11:18 PM

By Andrew Pociu (View Profile)

(Rated 0 with 0 votes)

More MySQL Resources

The query below will replace all occurences of "Bob Loblaw Law Blog" found in the field "BlogName" field of the Blogs table. All instances of the string are being replaced, and the search is case sensitive. The function is also multi-byte safe.

UPDATE Blogs SET BlogName = REPLACE(Blogs,'Bob Loblaw Law Blog','BLLB');

Digg It!

Del.icio.us Reddit

StumbleIt

Newsvine

Furl

BlinkList

Rate this Knowledge Base article

Current Comments

There are no comments.

Related Source Code

There is no related code.

MySQL Job Search

My skills include:

Enter a City:

Select a State:

Advanced Search >>

Latest Tech Bargains

Nokia 6085 Quad-Band GoPhone

$29.99 w/ free shipping

Crucial Ballistix Tracer Dual Channel 1GB DDR2 Memory

FREE after $35 rebate

Maxtor 500GB Ultra16 SATA II HDD

$49.99 w/ free shipping

Samsung A117 Prepaid w/ No Contract

$9.99 w/ free shipping

View More Bargains

Bargains RSS Feed

Free Magazine Subscriptions

InformationWeek

FREE SUBSCRIPTION
by CMP Media LLC

eWeek

FREE SUBSCRIPTION
by Ziff-Davis

Oracle Magazine

FREE SUBSCRIPTION
by Oracle Corporation

Macworld

FREE SUBSCRIPTION
by Mac Publishing LLC

View More Magazines

Today's Pictures

Wetkeys Washable Keyboard

Tags: Keyboard, Gadgets

Windows 7 Blue Wallpaper

Tags: Wallpaper, Windows 7

Orange-Red Toshiba Wallpaper

Tags: Toshiba, Wallpaper

View More Pictures

Today's Video

Microsoft Gaze

View More Videos

Other Resources

Latest Download

Building Line of Business Applications with WPF

View More Downloads

Latest Icons

View More Icons

News

Tutorials

Code

Resources

Newsgroups

Search and replace table field contents

Rate this Knowledge Base article

Current Comments

Comment on this Knowledge Base article

Related Knowledge Base Articles