FUDforum: FUDforum 3.0+ » Removing Multiple "re: " in subject lines

Home » FUDforum Development » FUDforum 3.0+ » Removing Multiple "re: " in subject lines

Show: Today's Messages :: Polls :: Message Navigator

Re: Removing Multiple "re: " in subject lines [message #183224 is a reply to message #183221]

Sat, 12 October 2013 22:32

GaryM

Messages: 118
Registered: May 2013
Location: Seattle

Karma:

Senior Member

I'm not seeing it here in my test area. Here is what I ran:

2 occurrences

select count(*)
from fud30_msg
where subject like '%Re: Re:%';
count(*)
0

A check to make sure my query makes sense:

1 occurrence

select count(*)
from fud30_msg
where subject like '%Re:%';
count(*)
1495

Edit: a better version of the second query, missing semicolon.

http://vintagegruen.org

[Updated on: Sat, 12 October 2013 23:13]

Report message to a moderator

[Message index]

		Removing Multiple "re: " in subject lines By: cpreston on Sat, 12 October 2013 19:11
		Re: Removing Multiple "re: " in subject lines By: GaryM on Sat, 12 October 2013 22:32
		Re: Removing Multiple "re: " in subject lines By: naudefj on Sun, 13 October 2013 07:20

Previous Topic:	Shouldn't "Delete all from user" also ban user?
Next Topic:	Problems charset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 23:37:17 GMT 2024

Total time taken to generate the page: 0.04120 seconds