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.
Bookmarks