Bit of a nasty hack query which I thought may be of use as a single-query
way of getting the From: and Subject: lines out of a message list.
Thought I'd post it in case it was of use to members on the list. If there
are any better ways of doing this -- please let me know!
/Mark
----------------------------------------------------------
select *,
left(substring(left(substring(messageblks.messageblk from locate('From',
messageblks.messageblk)), locate('\n', substring(messageblks.messageblk from
locate('From', messageblks.messageblk)))) from 6),30) as mailfrom,
left(substring(left(substring(messageblks.messageblk from
locate('Subject', messageblks.messageblk)), locate('\n',
substring(messageblks.messageblk from locate('Subject',
messageblks.messageblk)))) from 9),50) as subject,
from messages, messageblks
where
messages.message_idnr=messageblks.message_idnr
and messages.mailbox_idnr='-----INSERT MAILBOX NUMBER HERE -----'
group by messageblks.message_idnr
order by messages.internal_date desc
