Top
Search
Twitter
« Open selected text in TextMate with Automator | Main | Cleaner Facebook and Gmail »
Saturday
Feb112012

Find and replace with phpMyAdmin

DateSaturday, February 11, 2012 at 3:07PM

To find and replace in phpMyAdmin, use this:

UPDATE tablename SET fieldname = REPLACE(fieldname, "old", "new");

AuthorRobert Dawson | CommentPost a Comment |
in , ,

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

Notify me of follow-up comments via email.