29Apr/100
MySQL: Global find & replace
Global find & replace is easy in MySQL:
UPDATE table_name SET column_name = replace(column_name, "searchString", "replaceString");
Tagged as: MySQL, replace, update
No Comments
Pay Da Billz
Categories
- Cooking Recipies (1)
- Hockey (2)
- Misc (7)
- Music (3)
- Politics (12)
- San Diego (6)
- Wildfires 2007 (3)
- Tech (79)
- Apache (11)
- Apple (17)
- AppleTV (1)
- iPhone (6)
- App Store (1)
- iPod/iTunes (6)
- OS X (2)
- Database (4)
- MySQL (2)
- PostgreSQL (2)
- FCKeditor (3)
- FreeBSD (7)
- Google (1)
- Hardware (11)
- Linux (13)
- Mozilla (1)
- Thunderbird (1)
- phpList (6)
- Postfix/Sendmail (3)
- Programming (17)
- Windows (8)
- World of Warcraft (3)
Archives
Tags
aim
Apache
Apple
bash
cacti
crontab
express
FCKeditor
Fedora
firefox
FreeBSD
gop
Hockey
iphone
ipod
itunes
JavaScript
jQuery
katrina
leopard
libpng
Linux
macro
maxtor
MySQL
onetouch
osx
patriot
patriotism
PHP
phpList
postgre
redhat
republicans
RestorePoint.rbc
retrospect
San Diego
sendmail
sql
tco
Ubuntu
vim
warcraft
wildfires
x-authentication-warning