Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Noob question - phpadmin search and replace sql query - Please HELP

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 13-10-2011
Member
 
Join Date: Oct 2011
Posts: 1
Exclamation Noob question - phpadmin search and replace sql query - Please HELP
  

I just have a noob question. My coder is MIA and I have an issue to fix that could cost me a lot of time doing it manually.

Basically, I have a database with a unique identifier (blog_id), a set of 100 posts with the same user id (user_id) and I need to replace a link in the set of 100 posts with that user id. The link i need to replace is in the (content) column.

Basically, i need the query to SELECT the user_ID i have, and REPLACE the link in the (CONTENT) column that has that link that I want to change to the New link (I have both the new link and old link)

If someone could help me, I'd greatly appreciate it. I just need the right Sql query.

Reply With Quote
  #2  
Old 18-10-2011
Member
 
Join Date: May 2011
Posts: 103
Re: Noob question - phpadmin search and replace sql query - Please HELP

Don know if i am correct over here i would advise you to check the following code


Code:
UPDATE wp_posts1 SET post_content1 = REPLACE (post_content1, 'old link', 'new link');
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Noob question - phpadmin search and replace sql query - Please HELP"
Thread Thread Starter Forum Replies Last Post
SQL Query for different search. Hadcourt Software Development 6 31-05-2011 07:51 PM
Google query suggestions in the search box DHR Technology & Internet 7 19-08-2009 07:20 AM
SQL find and replace query Seraphim Software Development 3 26-05-2009 01:40 PM
LDAP Search Query Syntax etienne Active Directory 1 06-08-2008 07:47 PM
LDAP Search Query Error bjude Active Directory 3 17-03-2006 10:35 PM


All times are GMT +5.5. The time now is 01:47 AM.