[SOLVED] Find films with the same entry

[Steinninn]

Hi.

I'm using MySQL Query Browser number 1.2.12 but I'm not sure what the server version is.

 

It's a movie database. I'm trying to find any duplicated entries. So what would be the statement to find entries with the same title?

 

I could do

 

SELECT * FROM Kvikmyndir.Movie M

Order by Title

 

And search trough them, but that takes a long time.

 

I'm sorry if this is not enough information. Please tell me if I'm missing some key elements.

[toplay]

To find server version do:  select version();

 

To list dup titles:

 

select count(*) as number_of_dups, Title from Kvikmyndir.Movie group by Title having number_of_dups > 1;

 

 

[Hooker]

1.) how many records do you have in the table?

2.) Copy and paste your my.cnf file in here.

3.) What spec's do you have on the machine running the query?

[Steinninn]

Thanks. I used toplay suggestion. It worked.