> > Also, I was thinking about the REGEXP idea with respect to parsing only a > > subset of headers. REGEXP isn't universally support; we would need to do a > > hack similar to the date function hack, where the db.c uses an external > > symbol that is defined by the database shim as needed for that database. > > It works well, but I wonder if it wouldn't be easier to just do this: > > > > SELECT * FROM messageblks WHERE messageblk LIKE > > '%From:[EMAIL PROTECTED]'; > > > > Since LIKE works everywhere, and doesn't fire up a regex engine... well, > > benchmarking is in order, I think ;-) > > 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 Norell [EMAIL PROTECTED] is not my email address; change "administrator" to my first name. --
