将table表的url字段的www.abc.com/book/id/2.html修改为/book/id/2.html
sql语句为:update table SET url=REPLACE(url,'www.abc.com/','/')
将table表的url字段的www.abc.com/book/id/2.html修改为/book/id/2.html
sql语句为:update table SET url=REPLACE(url,'www.abc.com/','/')
Google Chrome
Windows 10
Google Chrome
Windows 10