mysql - 如果名称匹配，则按日期求和数量

Question

如果名称与 stripos($tocheck, "V2") 的匹配方式相同，如何按日期对某个值求和？

如果包含文本-“V2”，则按日期对所有“name”求和，如果不清楚，请询问，我真的不知道如何解释，但我会尽力给出如果需要的话，可以提供更多信息。

目前，这会获取所有数据并按天求和

$sql_download = "SELECT date, name, SUM(quantity) FROM downloads GROUP BY DATE(`Date`)";



`downloads` (`id`, `date`, `name`, `quantity`) VALUES
(1, '2015-05-13 23:30:09', 'CRCP03 - Cartoon Race Car Pack 03', 1),
(2, '2015-05-13 23:30:09', 'CRCPV2-01 - Cartoon Race Cars Pack V2 - 01', 1),
(3, '2015-05-14 00:30:09', 'CRCP03 - Cartoon Race Car Pack 03', 1),
(4, '2015-05-14 00:30:09', 'CRCPV2-01 - Cartoon Race Cars Pack V2 - 01', 1),
(5, '2015-05-14 07:05:07', 'CRCP03 - Cartoon Race Car Pack 03', 1),
(6, '2015-05-14 07:10:07', 'CRCP03 - Cartoon Race Car Pack 03', 1),
(7, '2015-05-14 12:05:00', 'CRCPV2-01 - Cartoon Race Cars Pack V2 - 01', 1),
(8, '2015-05-14 15:00:00', 'CRCPV2-01 - Cartoon Race Cars Pack V2 - 01', 1),
(9, '2015-05-14 17:10:06', 'CRCPV2-01 - Cartoon Race Cars Pack V2 - 01', 1),
(10, '2015-05-14 20:15:06', 'CRCPV2-01 - Cartoon Race Cars Pack V2 - 01', 1),
(11, '2015-05-14 21:50:06', 'CRCP03 - Cartoon Race Car Pack 03', 1),
(12, '2015-05-14 21:50:06', 'CRCPV2-01 - Cartoon Race Cars Pack V2 - 01', 1),
(13, '2015-05-15 12:00:07', 'CRCP03 - Cartoon Race Car Pack 03', 1),
(14, '2015-05-15 21:55:42', 'CRCPV2-01 - Cartoon Race Cars Pack V2 - 01', 1),
(15, '2015-05-15 23:47:07', 'CRCPV2-01 - Cartoon Race Cars Pack V2 - 01', 1),
(16, '2015-05-16 03:31:06', 'CRCP03 - Cartoon Race Car Pack 03', 1),

Answer 1

您只需添加 WHERE 条件来检查 name 是否匹配:

  SELECT date, name, SUM(quantity)
    FROM downloads
   WHERE name LIKE '%V2%'
GROUP BY DATE(`Date`)