Find and replace text in mysql

We're offering a special website package for small businesses in Australia. Contact us today to find out more.

26 May, 2006

Web Development » WordPress » Find and replace text in mysql

update TABLE_NAME set FIELD_NAME =
replace(FIELD_NAME,'find this string','replace it with this one');

Other similiar posts that you might be interested in:

2 Responses to "Find and replace text in mysql"

1 | Andy

April 8th, 2009 at 2:11 am

Just what I needed thank you

2 | Benxamin

April 9th, 2009 at 7:40 am

Oh HELL YES. Greatly appreciated.

I was pushing a WordPress site from development server to production server, and all the functions that called the ‘guid’ meta data from the page array were pointing back at the dev server.

This beats updating per line.

UPDATE wp_posts SET guid = REPLACE(guid, ‘dev.server.com’, ‘prod.server.com’);

Like a charm. Thanks again!

Comment Form

Mario: good tips, thanks!
Zyad Rujeedawa: Looks like this site has removed my coding :-) to prevent scripting attacks :-) So in the web.config file, under system.web, just set the property
Zyad Rujeedawa: For .net just add the following in the web.config file This will prevent scripting attacks.

Interests

Web development, Web design, Open source technologies, Portal development, APIs, Web services, Social media applications, Search engine optimisation, Mobile application development, iPhone Apps, Web 2.0, Web 3.0, Latest Internet technologies

Web Development Blog