- Original Message -
From: Harald Fuchs [EMAIL PROTECTED]
In article [EMAIL PROTECTED],
Jigal van Hemert [EMAIL PROTECTED] writes:
SELECT t1.`msg_id`
FROM `msg_content` AS t1
JOIN `msg_addressee` AS t2 ON t1.`msg_id` = t2.`msg_id` AND
FIND_IN_SET( t2.`status` , 'deleted'
In article [EMAIL PROTECTED],
Jigal van Hemert [EMAIL PROTECTED] writes:
Two tables (simplified, because other fields are not used in query; indexes
other than primary key removed):
CREATE TABLE `msg_content` (
`msg_id` int(14) NOT NULL auto_increment,
`subject` varchar(255) NOT NULL
Two tables (simplified, because other fields are not used in query; indexes
other than primary key removed):
CREATE TABLE `msg_content` (
`msg_id` int(14) NOT NULL auto_increment,
`subject` varchar(255) NOT NULL default '',
`content` mediumtext NOT NULL,
PRIMARY KEY (`msg_id`),
)