用“Re：”替换所有条目 [英] Replacing all entries with "Re:"
问题描述
好的，这就是......我有一个vBulletin论坛数据库......那里有一个名为post的
表。其中包含我所有的论坛帖子。
我所拥有的很多帖子都有普通的标题，比如哦，你好，怎么样？/ b
you或者其他什么，以及许多帖子（回复）和Re：之前
他们以及随后的任何消息。
我最近更新了我的论坛，不是为了展示Re：的东西，我需要
a快速执行查询或清除所有标题的东西
有这个Re：在邮政表条目的标题区域。
任何人都知道我该怎么做？
该表名为post和单元格（？）我猜是叫标题。
这个帖子表中有超过8,000个条目所以我真的需要
找到一种有效的方法来删除所有标题Re： ...
手动太长太难了。
感谢您的帮助....顺便说一下我正在运行MySQL版本4.0.25我
相信。
< ss ****** @ gmail .COM>在消息中写道
news：11 ********************** @ f14g2000cwb.googlegr oups.com ...好的，这就是......我有一个vBulletin论坛数据库......那里有一个名为post的表。其中包含我所有的论坛帖子。
我所拥有的很多帖子都有普通的标题，比如哦，你好，你好吗？或者其他什么，以及许多帖子（回复）和Re：在
之前以及随后发生的任何消息。
我最近更新了我的论坛，不是为了展示Re：的东西，我需要一个快速的方法来执行查询或其他什么这将清除所有具有此Re：的标题。在帖子表条目的标题区域。
任何人都知道如何做到这一点？
该表名为post我认为单元格（？）被称为标题。
这个帖子表中有超过8,000个条目，所以我真的需要找到一种有效的方法来删除所有的带有Re：的标题...
手动太长太难了。
感谢您的帮助....顺便说一句，我正在运行MySQL 4.0.25版本我
相信。
嗯 - 你想做什么？它有助于具体化！
目前还不清楚您是在尝试查询还是希望实际修改表格中的数据
。
------------------------------------
查询仅适用于不开始的标题Re：
SELECT title
FROM post
WHERE NOT（ title LIKE''Re：％''）
-------------------------------- ----------
查询所有标题但隐藏前导Re：
SELECT标题
IF（LEFT（title，3）=''Re''，RIGHT（title，LENGTH（title）-3），title）as
AdjustedTitle
来自帖子
---------------------------------------- ----
当你说清除时，你当然不是要删除那些记录。
删除帖子
标题类似于''Re：'';
------------------------- -----------------------
或许你想保留记录但删除前导Re：来自
[标题]在表格中！
更新帖子
SET title = LEFT（title，3）=' 'Re''，RIGHT（标题，长度（标题）-3）
标题类似于''Re：'';
-------- -------------------------------------------------
Thomas Bartkus
< ss ****** @ gmail.com>在消息中写道
news：11 ********************** @ f14g2000cwb.googlegr oups.com ...好的，这就是......我有一个vBulletin论坛数据库......那里有一个名为post的表。其中包含我所有的论坛帖子。
我所拥有的很多帖子都有普通的标题，比如哦，你好，你好吗？或者其他什么，以及许多帖子（回复）和Re：在
之前以及随后发生的任何消息。
我最近更新了我的论坛，不是为了展示Re：的东西，我需要一个快速的方法来执行查询或其他什么这将清除所有具有此Re：的标题。在帖子表条目的标题区域。
任何人都知道如何做到这一点？
该表名为post我认为单元格（？）被称为标题。
这个帖子表中有超过8,000个条目，所以我真的需要找到一种有效的方法来删除所有的带有Re：的标题...
手动太长太难了。
感谢您的帮助....顺便说一句，我正在运行MySQL 4.0.25版本我
相信。
嗯 - 你想做什么？它有助于具体化！
目前还不清楚您是在尝试查询还是希望实际修改表格中的数据
。
------------------------------------
查询仅适用于不开始的标题Re：
SELECT title
FROM post
WHERE NOT（ title LIKE''Re：％''）
-------------------------------- ----------
查询所有标题但隐藏前导Re：
SELECT标题
IF（LEFT（title，3）=''Re''，RIGHT（title，LENGTH（title）-3），title）as
AdjustedTitle
来自帖子
---------------------------------------- ----
当你说清除时，你当然不是要删除那些记录。
删除帖子
WHERE title LIKE''Re：％'';
------------------------ ------------------------
或许你想保留它e记录但删除前导Re：来自
[标题]在表格中！
更新帖子
SET title = LEFT（title，3）=' 'Re''，RIGHT（标题，LENGTH（标题）-3）
标题类似'Re：％'';
------- --------------------------------------------------
Thomas Bartkus
嘿Thomas！
谢谢你帮助我
继承人我需要做什么
我有一张名为post的表，还有一个名为title的部分....
吨和我所有参赛作品的大量标题，但我想清除所有包含Re：的标题。在他们中只有没有Re：
的人留下来。
非常感谢你的帮助！
Ok here''s the thing... I have a vBulletin forum database... there is a
table in there called "post" which has all of my forums posts in it.
What I have are many posts with regular titles like "Oh hello how are
you" or whatever, and many posts (which are replies) with "Re:" before
them and whatever message following that.
I have recently updated my forums not to show the Re: thing, and I need
a quick way to execute a query or something that will CLEAR all titles
that have this "Re:" in the title area of the post table entries.
Anyone know how I can do this?
The table is called "post" and the cell (?) I guess is called "title."
There are over 8,000 entries in this post table so I really need to
find an efficient way to remove all of the titles with "Re:" ...
manually is just too long and too hard.
Thanks for your help.... by the way I''m running MySQL version 4.0.25 I
believe.
<ss******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...Ok here''s the thing... I have a vBulletin forum database... there is a
table in there called "post" which has all of my forums posts in it.
What I have are many posts with regular titles like "Oh hello how are
you" or whatever, and many posts (which are replies) with "Re:" before
them and whatever message following that.
I have recently updated my forums not to show the Re: thing, and I need
a quick way to execute a query or something that will CLEAR all titles
that have this "Re:" in the title area of the post table entries.
Anyone know how I can do this?
The table is called "post" and the cell (?) I guess is called "title."
There are over 8,000 entries in this post table so I really need to
find an efficient way to remove all of the titles with "Re:" ...
manually is just too long and too hard.
Thanks for your help.... by the way I''m running MySQL version 4.0.25 I
believe.
Well - what is it you want to do? It helps to be specific!
It is unclear whether you are trying to query or you wish to actually modify
the data in your table.
------------------------------------
Query for only titles that don''t begin "Re:"
SELECT title
FROM post
WHERE NOT (title LIKE ''Re:%'')
------------------------------------------
Query all titles but hide the leading "Re:"
SELECT title
IF (LEFT(title,3)=''Re'', RIGHT(title, LENGTH(title)-3), title) As
AdjustedTitle
FROM post
--------------------------------------------
Surely you didn''t mean to delete those records when you said "CLEAR"
DELETE FROM post
WHERE title LIKE ''Re:'';
------------------------------------------------
Or perhaps you meant to keep the records but remove the leading "Re:" from
[titles] in the table post !
UPDATE post
SET title = LEFT(title,3)=''Re'', RIGHT(title, LENGTH(title)-3)
WHERE title LIKE ''Re:'';
---------------------------------------------------------
Thomas Bartkus
<ss******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...Ok here''s the thing... I have a vBulletin forum database... there is a
table in there called "post" which has all of my forums posts in it.
What I have are many posts with regular titles like "Oh hello how are
you" or whatever, and many posts (which are replies) with "Re:" before
them and whatever message following that.
I have recently updated my forums not to show the Re: thing, and I need
a quick way to execute a query or something that will CLEAR all titles
that have this "Re:" in the title area of the post table entries.
Anyone know how I can do this?
The table is called "post" and the cell (?) I guess is called "title."
There are over 8,000 entries in this post table so I really need to
find an efficient way to remove all of the titles with "Re:" ...
manually is just too long and too hard.
Thanks for your help.... by the way I''m running MySQL version 4.0.25 I
believe.
Well - what is it you want to do? It helps to be specific!
It is unclear whether you are trying to query or you wish to actually modify
the data in your table.
------------------------------------
Query for only titles that don''t begin "Re:"
SELECT title
FROM post
WHERE NOT (title LIKE ''Re:%'')
------------------------------------------
Query all titles but hide the leading "Re:"
SELECT title
IF (LEFT(title,3)=''Re'', RIGHT(title, LENGTH(title)-3), title) As
AdjustedTitle
FROM post
--------------------------------------------
Surely you didn''t mean to delete those records when you said "CLEAR"
DELETE FROM post
WHERE title LIKE ''Re:%'';
------------------------------------------------
Or perhaps you meant to keep the records but remove the leading "Re:" from
[titles] in the table post !
UPDATE post
SET title = LEFT(title,3)=''Re'', RIGHT(title, LENGTH(title)-3)
WHERE title LIKE ''Re:%'';
---------------------------------------------------------
Thomas Bartkus
Hey Thomas!
Thanks for helping me out
heres what I need to do
I have a table, called post, and theres a section called "title" ....
tons and tons of titles on all my entries, but I want to clear out all
the titles that contain "Re:" in them so that only ones without "Re:"
remain.
Your help is greatly appreciated!
这篇关于用“Re：”替换所有条目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
