Search and Replace in MySQL database with phpMyAdmin
UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");
- Web Address: http://www.zimmertech.com/tutorials/php/60/mysql-search-replace-phpmyadmin.php
- Short Name: clekaji
-
Short Link: http://ma.gnolia.com/clekaji
-
Tags: mysql, search and replace
- Saved by Ivan Storck on April 06, 2008.
Bookmark licensed under Creative Commons Attribution Non-commercial Share Alike 2.5.
2 other people have commented on this bookmark
| Name | Title | Rating | When | |
|---|---|---|---|---|
 |
Dan | Search and Replace in MySQL database with phpMyAdmin |
Rated stars out of 5.
|
September 16, 2007 |
I don't mess with MySQL much at all, so this kind of thing is quite handy. Saved me a few hours of line-by-line changes to a DB tonight. |
||||
 |
David | Search and Replace in MySQL database with phpMyAdmin |
Not rated yet.
|
October 13, 2005 |