By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS `textsearch` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`duration` bigint(20) DEFAULT NULL,
`timer` datetime DEFAULT NULL,
`search_text` varchar(1000) DEFAULT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`search_text`)
);
insert into textsearch values
(1,15,'2022-02-21', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras sed orci sollicitudin, porta risus hendrerit, pretium diam. Donec mauris leo, ultricies convallis turpis et, lacinia viverra elit. Fusce tellus libero'),
(2,20,'2022-02-21', 'Lorem Nunc non semper tellus. Vivamus congue eget quam sit amet bibendum. Vivamus eros odio, tincidunt ac enim vel, semper lacinia nisi'),
(3,25,'2022-02-21', 'aliquet a dignissim eget, mattis non purus. Aenean in augue sed turpis mattis luctus. Phasellus vel augue id eros vehicula finibus');
Records: 3 Duplicates: 0 Warnings: 0
SELECT *
FROM textsearch t
WHERE t.timer BETWEEN '2022-02-01' AND '2022-02-28'
HAVING MATCH (t.search_text) AGAINST ('+lorem +ipsum' IN BOOLEAN MODE)
| id | duration | timer | search_text |
|---|---|---|---|
| 1 | 15 | 2022-02-21 00:00:00 | Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras sed orci sollicitudin, porta risus hendrerit, pretium diam. Donec mauris leo, ultricies convallis turpis et, lacinia viverra elit. Fusce tellus libero |
WITH cte as (
SELECT *
FROM textsearch t
WHERE t.timer BETWEEN '2022-02-01' AND '2022-02-28'
HAVING MATCH (t.search_text) AGAINST ('+lorem +ipsum' IN BOOLEAN MODE)
)
select sum(duration)
from cte;
| sum(duration) |
|---|
| 15 |