![](https://cdn.lihkg.com/assets/faces/dog/touch.gif)
當然要where 埋每次match 既第一句咁樣select 到出黎都未必係開場白Admin做野洗你教select count(distinct(message)) as count from message order by count desc limit 10
即係話直接係數據庫搵最多果10句出黎
依家為止有330萬條記錄 根本無可能逐條睇
我都決定左唔公開記錄
但太長無謂係到解釋 大家都未必明
select message, count(message) as count from message where sno=1 order by count desc limit 10