MYSQL如何实现多次查询取重复结果

问题：大致就是上面的表，如果想查keyname既是 '前端' 又是** 'CSS' **的blogid该怎么写sql语句呢？(_来自前端小白的请教)_

SELECT
distinct t1.blogid
FROM
table AS t1 inner join (SELECT * FROM table) as t2 on t1.blogid = t2.blogid
WHERE
t1.keyname = 'CSS'
AND t2.keyname = '前端';