Question

我的表格是:

http://www.ohchr.org。

页: 1

<<> >

每一机构都包含从以前的CMS中编出的编号为 php/html的代码,在标签之间封顶[标签][/soltag]。

例如,一个记录就是这样:

Lorem Ipsum has been the industry s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting
[soltag]php, $end = ""; if (isset($_GET["vote"])) { $end .= "?vote=" . $_GET["vote"]; if (isset($_GET["vid"])) { $end .= "&vid=" . $_GET["vid"]; }; }; $output = file_get_contents("http://example.com/something.html" . $end);[/soltag] And the body text continues here.

我也想从数据库中的每一记录中删除包括这些标的两面之间的一切。

因此,在这样做之后,它应当考虑:

Lorem Ipsum has been the industry s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting  And the body text continues here.

我有5 000份手工记录,至少消耗2-3天的机器人类的工作。

有什么想法,我怎么能够用我的智慧来消除这种情况?

提前感谢。

Answer 1

我正在寻找同样的目的,这确实是有用的。

接下来,就同一问题进行搜查。

如果你也想去掉最后的标签,就应当把关闭的帽子在《战略》第3条论点中的足迹:

UPDATE experiences SET [本人] = REPLACE([本人])

                 SUBSTRING([body], 
                           INSTR([body], [soltag] ), 
                           INSTR([body], [/soltag] ) +CHAR_LENGTH( [/soltag] ) -INSTR([body], [soltag] )
                          )
                 ,  );

Hope that helps someone! :)

Answer 2

使用SUBSTRING( and <>/code><><><>>>>>>>>

在更新该栏之前,确保有正确的数据。

SELECT REPLACE([body],
                     SUBSTRING([body], 
                               INSTR([body], [soltag] ), 
                               INSTR([body], [/soltag] ) -INSTR([body], [soltag] )
                              )
                     ,  ) AS NewBody
From [stories]

如<代码>INSTR(>不适用,则按需要作上述调整。

然后可以更新本表的所有栏目。

UPDATE stories
SET [body] = REPLACE([body],
                     SUBSTRING([body], 
                               INSTR([body], [soltag] ), 
                               INSTR([body], [/soltag] ) -INSTR([body], [soltag] )
                              )
                     ,  )

友情链接