Subscribe to
Posts
Comments
NSLog(); Header Image

Find and Replace in MySQL

Posted October 26th, 2006 @ 01:40am by Erik J. Barzeski

This has come in handy the past few days. If only I could do it with regular expressions… and if only I knew regular expressions! 🙂

update [table_name] set [field_name] = replace([field_name], '[string_to_find]', '[string_to_replace]');

Works like a charm… though I'm not entirely sure how to replace line breaks. Some of my MT entries have four line breaks where they should have two.

2 Comments »

2 Responses to "Find and Replace in MySQL"

  1. | Reply The Plaid Cow
    Posted 26 Oct 2006 at 8:47am #

    There is also a plugin to do SQL search and replace from within WordPress.

  2. | Reply Frode Danielsen
    Posted 28 Oct 2006 at 9:25pm #

    You do have POSIX Regexp support in MySQL, but as far as I know you can only do matching and not replacing with it..


Comments RSS

Leave a Reply to The Plaid Cow

Please abide by the comment policy. Valid HTML includes: <blockquote><p>, <em>, <strong>, <ul>, <ol>, and <a href>. Please use the "Quote Me" functionality to quote comments.