Find duplicate rows on specific value

[budimir]

Hi,

 

I need some help with the query to find duplicate rows on specific value. I have tried many queries, but I can't find it. For now I have this.

 

My sql structure:

  id INT(11) NOT NULL AUTO_INCREMENT,
  vrijeme TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  pocetni_broj VARCHAR(55) DEFAULT NULL,
  zamjenski_broj VARCHAR(55) DEFAULT NULL,
  glavni_broj VARCHAR(55) DEFAULT NULL,
  postoji_zamjena INT(1) DEFAULT NULL,
  PRIMARY KEY (id)

And my query is:

SELECT *
FROM zamjene_brojeva
GROUP BY glavni_broj
HAVING COUNT(glavni_broj) > 1

Thta is giving me all duplicate values in table. But how do I find duplicate values where column glavni_broj has value 966 45 19-68? I know that there is 4 rows with that value in glavni_broj. I have tried to put Where in that, but than query fails.

 

Any ideas how to do it?

[QuickOldCar]

Query like this failed?

 

SELECT *
FROM zamjene_brojeva

WHERE glavni_broj='966 45 19-68'
GROUP BY glavni_broj
HAVING COUNT(glavni_broj) > 1

[budimir]

Query like this failed?

 

SELECT *

FROM zamjene_brojeva

WHERE glavni_broj='966 45 19-68'

GROUP BY glavni_broj

HAVING COUNT(glavni_broj) > 1

 

Yes, it didn't return any results.

[Barand]

if you run this query

SELECT *
FROM zamjene_brojeva
WHERE glavni_broj='966 45 19-68'

does it list those four records?

[benanamen]

You will get better quicker answers if you post an SQL dump of your DB.

[budimir]

Guys, thanks for all you're help. I found a problem and it was on another script that was inserting data into that table. Something happened during the scheduled start and it didn't finish inserting all the records. Found the problem, fixed it and now I can get all the records I need.

 

Once again, thanks for you're help.