Updating url prefix with mysql query

Question

I have imported my database by script from live site to my local server.

I have menu system dynamically generated by database. they are in table like below:

id   name     linkpage
1    blog     http://www.example.com/blog/index.php
2    about    http://www.example.com/blog/about.php

How can I update link page column with mysql query ?

user319198 · Accepted Answer · 2012-04-05 16:45:09Z

3

It's simple. You can do with replace function:

 UPDATE tablename SET linkpage=REPLACE(linkpage,'www.example.com','localhost/nysite')

answered Apr 5, 2012 at 16:45

user319198

Sign up to request clarification or add additional context in comments.

Comments

Alfred · Accepted Answer · 2012-04-05 17:42:53Z

0

with replace function;

mysql_query("UPDATE your_tablename SET linkpage=REPLACE(linkpage,'www.your_link.com','localhost/mysite')")

answered Apr 5, 2012 at 17:42

Alfred

21.5k64 gold badges175 silver badges258 bronze badges