MySQL find and replace

Written by Dave Nicholls. Tags: , ,

A really useful MySQL query for finding and replacing a value within a field in all records:

UPDATE `[table_name]`
SET `[field_name]` = REPLACE(`[field_name]`,'[string_to_find]','[string_to_replace]');

Needless to say, take extreme care when using a query like this that affects multiple records – backup first!

See the MySQL manual for more information.

Stop using IE7 and get a Free new computer

It sounds incredible, but a US company is offering a brand new computer to it’s…

One last fix for XP…

Despite months/ years of warnings about no updates for Windows XP after April…

First post Windows XP security issue?

is this the first

Top 5 reasons why super fast broadband is good for business

Super fast broadband continues to be rolled out in Leicestershire, but what…

Another earthquake hits Rutland

This made us chuckle: After the devastating news of the third earthquake to…

What is Cloud Computing?

Cloud Computing is the latest IT Jargon and seems to relate to everything new…

Better-IT Limited

3-3a Barrow Road, Sileby, Leicestershire, LE12 7LW.


t: 0333 202 6365

Find us on:
Google Maps


Copyright © 2019 Better-IT Limited.
Page loaded in 0.885 seconds.