What to do to find a duplicate titles...

Thank you..

Do you mean like duplicate URL check, but for duplicate titles? Hmm.. You could try entering this:

SELECT ID, Title, URL, COUNT(*) as hits
FROM Links
GROUP BY Title
HAVING hits > 1
ORDER BY hits DESC
LIMIT 10

into SQL monitor and it will print out a list of duplicates.

Hope this helps,

Alex

I don't see a problem with duplicate titles, for a lot of reasons... but if you do not want them --

You can check for duplicate titles the way Alex suggested, but you might want a more permanent solution.

What about making the Title field "Unique"

That would prevent people from entering duplicate titles, but you'd need to make sure you did the right error checking to tell them that they need to pick a different title.

So many sites have the same titles, though, this might create more problems than it solves.

The URL should be unique, but that prevents duplicate listings (That's ok, since you can put a link into alternate categories).



------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/

OK.. I've tried it into SQL monitor.
But comes to an error :


what happened ?

Check the resource center:

http://www.gossamer-threads.com/...es/Detailed/609.html

I think this addresses your problem.

OK! It works.

Thank you all.