MySQL 查询某一个字段重复的所有数据

//查询名称重复的数据
SELECT
	id,
	material_code,
	material_name
FROM
	t_material
WHERE
	material_code IN (
		SELECT
			material_code
		FROM
			t_material
		GROUP BY
			material_code
		HAVING
			COUNT(1) > 1
		AND material_code = '288'
	);