beklager de mange ens indlæg, mit net gik net lige som jeg sendte, også er indlægget gensendt flere gange :(
ref
http://stackoverflow.com/questions/4519582/how-to-select-non-unique-rows
SELECT T1.*
FROM scener AS T1
JOIN
(
SELECT `DVDID`
FROM scener
GROUP BY `DVDID`
HAVING COUNT(*) > 1
) T2
ON T1.`DVDID` = T2.`DVDID`
test tabel
CREATE TABLE `scener` (
`id` int(11) NOT NULL,
`MovieID` int(11) NOT NULL,
`DVDID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
INSERT INTO `scener` (`id`, `MovieID`, `DVDID`) VALUES
(1, 20, 432),
(2, 21, 432),
(3, 22, 436),
(4, 23, 185);
ALTER TABLE `scener`
ADD PRIMARY KEY (`id`);
ALTER TABLE `scener`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
output
id, MovieID, DVDID
1, 20, 432
2, 21, 432