如何在mysqlphp中显示特定单词的出现

Question

我是mysql PHP的新手。我想统计MySQL数据库行中特定单词的出现次数。例如：有两列name和jobdataus。

>日期成//tr>成[/tr>022-09-22[/tr>022-09-22022-09-22[/tr>2022-09-23年022-09-23取消<2022-09-23>成取消取消<2022-09-24>td style="text align=left；">17022-09-24//tr>td style="text-align:left；">19td style="text-align:left；">20td style="text-align:left；">21成

id	名称	job_status
1	umar	2022-09-22
22022-09-22
3	umar	2022-09-22
4	umar	重新预订
5	umar	重新预订
6	umar
7	umar	重新预订
9	umar	重新预订
10	umar	重新预订
11	umar	2022-09-23三个
12	umar
13	umar	2022-09-23
14	umar		15	khan
16	khan	重新预订	khan	已取消
18	khan	重新预订	khan	完成	khan	重新预订	khan

您可以使用GROUPING和子查询。

SELECT `date`, `name`,
(SELECT COUNT(*) FROM `specific` WHERE `job_status`='done' AND `name`=s1.`name`) AS total_done,
(SELECT COUNT(*) FROM `specific` WHERE `job_status`='rebook' AND `name`=s1.`name`) AS total_rebook,
(SELECT COUNT(*) FROM `specific` WHERE `job_status`='cancelled' AND `name`=s1.`name`) AS total_cancelled
FROM `specific` AS s1 WHERE 1 GROUP BY `name`

输出

日期
2022-09-22		2022-09-24