news_007_broadcast
新闻联播文字稿, 每天一行
3 个字段
本表是新闻联播的文字稿,每天一行,正文为当天各条新闻按播出顺序拼接的全文。
-- 某段时间的文字稿SELECT date, contentFROM news_007_broadcastWHERE date >= '2026-11-01' AND date < '2026-11-08'ORDER BY date
-- 提到某个关键词的日期SELECT dateFROM news_007_broadcastWHERE date >= '2025-01-01' AND content LIKE '%新质生产力%'ORDER BY date
SELECT date, content, entry_time FROM news_007_broadcast WHERE date >= '2026-10-22' ORDER BY date LIMIT 100