· 9 years ago · Nov 09, 2016, 09:26 AM
1CREATE TABLE IF NOT EXISTS `mails` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `to` varchar(255) NOT NULL,
4 `object` varchar(30) NOT NULL,
5 `data` text NOT NULL,
6 `temp_id` int(11) NOT NULL,
7 `mailing_id` int(11) NOT NULL,
8 `priority` tinyint(1) NOT NULL,
9 `send_time` datetime NOT NULL,
10 `error` tinyint(1) NOT NULL,
11 PRIMARY KEY (`id`)
12) ENGINE=MyISAM DEFAULT CHARSET=utf8;
13
14SELECT `id`, `to` FROM `mails` WHERE (`to` LIKE 'info@mail.ru' OR `to` LIKE 'info@mail.ru,%' OR `to` LIKE '%,info@mail.ru' OR `to` LIKE '%,info@mail.ru,%') AND `mailing_id` = 172