PHP/MySQL-在表中选择每种类型之一 [英] PHP/MySQL - Select One of Each Type In Table

问题描述

我正在创建一个具有许多不同类别的博客，并且我想在我的主页上显示每个类别的一篇文章(也许杂项"除外)，但是我不确定是否有一个简单的一线解决方案这.我希望有一些类似的东西:

I'm creating a blog with many different categories and on my home page I'd like to show one post from each category (except maybe "miscelanious") but I'm not sure if there's a simple one line solution for this. I'm hoping for something along the lines of:

"SELECT * FROM blogs WHERE cat != 'misc' ORDER BY added LIMIT (ONE OF EACH CAT TYPE)"

这样可能吗?

推荐答案

仅GROUP BY类别-

SELECT * 
FROM blogs WHERE cat != 'misc' 
GROUP BY cat
ORDER BY added 

这篇关于PHP/MySQL-在表中选择每种类型之一的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！