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.
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
UPDATE wp_posts1 SET post_content1 = REPLACE (post_content1, 'old link', 'new link');
|Tags: database, mia, query, replace function, sql|
|Thread Tools||Search this Thread|
|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|