Unix and Linux network configuration. Multiple network interfaces. Bridged NICs. High-availability network configurations.


Reviews of latest Unix and Linux software. Helpful tips for application support admins. Automating application support.


Disk partitioning, filesystems, directories, and files. Volume management, logical volumes, HA filesystems. Backups and disaster recovery.


Distributed server monitoring. Server performance and capacity planning. Monitoring applications, network status and user activity.

Commands & Shells

Cool Unix shell commands and options. Command-line tools and application. Things every Unix sysadmin needs to know.

Home » MySQL

Find and Replace in MySQL

Submitted by on December 28, 2005 – 11:34 am One Comment

A simple one-line command to perform find and replace operations in MySQL:

update TABLE set COLUMN = replace(COLUMN, 'OLD_VALUE', 'NEW_VALUE');
Print Friendly, PDF & Email

One Comment »

  • Cupcakerum says:


    I’m going to build a high scale site in php/mysql that needs to scale horizontally.

    What things should the developer do and not do when writing the code and creating the database?


Leave a Reply

%d bloggers like this: