MySQL REPLACE变量字符串 [英] MySQL REPLACE variable string

问题描述

我想使用MySQL查询来更改链接.

I want to use MySQL query to change a link .

链接是这样的:

http://website.com/click.php? ad_client = blablabla& add_id = 548124& more = stuffhere

如果我知道add_id号，这很简单:

if I know the add_id number this is easy :

UPDATE table SET name = REPLACE(name, '&add_id=548124', '')

问题是我必须更改5000行，但我不知道add_id号...所以删除& add_id = somenumber 的正确的mysql replace()代码是什么? em> ??

The problem is I have to change 5000 lines and I don't know the add_id number ... so what would be a correct mysql replace() code to remove &add_id=somenumber ??

推荐答案

使用此....

 UPDATE table 
    SET name = CONCAT(SUBSTRING(name , 1, 
                    INSTR(name ,'&add_id') - 1),SUBSTRING(name , 
                    INSTR(name , '&more'), 
                    LENGTH(name ) - INSTR(name , '&add_id')))

这篇关于MySQL REPLACE变量字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！