Jesse Norell wrote:
SELECT * FROM messageblks WHERE messageblk LIKE
'%From:[EMAIL PROTECTED]';
Won't work. LIKE is like a multiline regexp. So you might do:
'%From: [EMAIL PROTECTED]' but
'%From:[EMAIL PROTECTED]' would match any messages that contain
[EMAIL PROTECTED] in any header including and
after the From: header.
I'm sure you'd be in violation of the rfc if you did *not* do
a multiline search at the database level, because rfc [2]822 headers
support folding whitespace.
Jesse, you missed my point:
'%From:[EMAIL PROTECTED]' would also match:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: asdf asdf asdf
Deliver-to: [EMAIL PROTECTED]
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
