MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.4 > MyBB 1.4 General Support > any sql query to replace
Full Version: any sql query to replace
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

remshad

2010-05-12, 08:11 AM
hey sire

am a beginner in web programming(please help me) , problem is

my previous domain was http://www.college-seminars.com but now i changed domain address to http://www.seminarprojects.com , but in my some post (almost 500) previous domain name was posted for resource referral..


do i have any sql query to replace from college-seminars.com to seminarprojects.com in my database all tables


(because all links changed to seminarprojects.com)

luke83

2010-05-12, 11:09 AM
UPDATE `your_table` 
SET 
your_field = REPLACE(your_field, 'http://www.college-seminars.com', 'http://www.seminarprojects.com ')
WHERE 1

remshad

2010-05-13, 04:30 AM
what i have to write in the place of "your_field''
thanks i did it

works fine.............................
a lot thankzzzzzzzz...
[Image: kiss_graphics_02.gif]

luke83

2010-05-13, 07:52 AM
you're welcome Big Grin
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.4 > MyBB 1.4 General Support > any sql query to replace