wordpress help search and replace - GoFuckYourself.com

zoddy · 09-22-2009, 08:12 AM

ok here is the situation

Most of my posts have the regular text color and then a the bottom some different color text I put in manual via html. Now I am getting a new blog template and that color will not look good on the new template.

So I have to go into each post and manually change each HTML color Code to another HTML color code, problem is there is like 250 posts... I tried the search and replace plugin by wordpress but it didnt do anything, it found the entries but didnt change them.

Any other suggestions

Cyber Fucker · 09-22-2009, 11:14 AM

hmm... maybe it would be a bit easier if you edited mysql db directly to change the code.. bump for you

zoddy · 09-22-2009, 01:49 PM

sheesh that is a good idea, I have done that in the past, just been so long I forgot, thanks for the reminder

scriptguy · 09-23-2009, 05:07 AM

If you have hundreds of posts I don't think that's a good ideea, you'll need to use some sql commands for a search and replace. If you don't manage I can help you out.

mattpone · 09-23-2009, 08:37 AM

if you have something like phpmyadmin installed it shouldnt be too hard to edit the mysql database? good luck

czarina · 09-23-2009, 08:58 AM

try this plugin:
http://wordpress.org/extend/plugins/search-and-replace/

Cyber Fucker · 09-23-2009, 10:24 AM

Quote:

Originally Posted by czarina

try this plugin:
http://wordpress.org/extend/plugins/search-and-replace/

You didn't read his post carefully, did you?

zoddy · 09-24-2009, 09:59 AM

actually i didnt use the plugin carefully, seems it is case sensitive and I am an idiot, the plugin works great

09-22-2009, 08:12 AM	#1
zoddy Confirmed User Join Date: Oct 2006 Posts: 280	wordpress help search and replace ok here is the situation Most of my posts have the regular text color and then a the bottom some different color text I put in manual via html. Now I am getting a new blog template and that color will not look good on the new template. So I have to go into each post and manually change each HTML color Code to another HTML color code, problem is there is like 250 posts... I tried the search and replace plugin by wordpress but it didnt do anything, it found the entries but didnt change them. Any other suggestions

09-22-2009, 11:14 AM	#2
Cyber Fucker Hmm Industry Role: Join Date: Sep 2005 Location: On an endless road around the world for rock and roll. Posts: 12,642	hmm... maybe it would be a bit easier if you edited mysql db directly to change the code.. bump for you __________________

09-23-2009, 05:07 AM	#4
scriptguy Confirmed User Join Date: Sep 2009 Location: Underground. Posts: 287	If you have hundreds of posts I don't think that's a good ideea, you'll need to use some sql commands for a search and replace. If you don't manage I can help you out. __________________ ICQ: 260892954 PHP / MySQL / AJAX Programmer. I can also work with JAVA, Objective-C and Python Contact Page

09-22-2009, 01:49 PM	#3
zoddy Confirmed User Join Date: Oct 2006 Posts: 280	sheesh that is a good idea, I have done that in the past, just been so long I forgot, thanks for the reminder

09-23-2009, 08:37 AM	#5
mattpone Registered User Join Date: Sep 2009 Posts: 3	if you have something like phpmyadmin installed it shouldnt be too hard to edit the mysql database? good luck

09-23-2009, 08:58 AM	#6
czarina Webmaster Extraordinaire Industry Role: Join Date: Jul 2002 Location: A beautiful beach... Posts: 10,748	try this plugin: http://wordpress.org/extend/plugins/search-and-replace/

09-24-2009, 09:59 AM	#8
zoddy Confirmed User Join Date: Oct 2006 Posts: 280	actually i didnt use the plugin carefully, seems it is case sensitive and I am an idiot, the plugin works great