How to find dublicate content on directory

Hello,
Can anyone suggest how to check for dublicate entries in directory?
Is there sime tool in phpld or some free service online that can check for dublicate content within the site?
I was googling a bit, but found only sites that check for plagarism.
Thank you!

 

Copyscape.com might or might not give you what you want. You can use the sort facilities to sort Alphabetically. Myself, I would use SQL to sort by URL.

 

Good advice

@stinker

Run:

to get list of all URLs in your directory MySQL DB

fastreplies

 

Thank you for your support, CanadianEh and Fastreplies!

One question:
Shall i run this request in 'PhpMyAdmin' or inside 'Directory' admin 'database' area?

Shall i add this command in '''Run SQL query on database''' big field and press 'run query'?
(if so, then i probably doing something wrong, im getting error)
Im still a bit clueless regarding MySQL so i may ask dumb questions

By the way, which program is better for exploring and editing DB copy in PC (also maybe with ability to sort alphabetically) - maybe word, or excel?

 

That query is working for me but maybe my tables have different values than your.
Check how your script addresses URL and links. Some may use $url for example.
phpMyAdmin is OK to use

Get for yourself good NotePad program that will have sorting and find duplicates options



fastreplies

 

Jut did run: SELECT url FROM PLD_LINK (my link table name)

Looks like it worked, but nothing happened exept this confirmation
But at least in phpmyadmin it works!

I can not yet get a clue what format to download to be able to open in word or notepad sql database to use with convenience

 

what do you mean duplicate content in directory?Directory didn't allow duplicate articles it will be remove once they find it out.

 

I think he means about the Descriptions in the categories.

 

Hope Copyscape would serve you better. Its really a nice tool to prevent content theft.

 

Copyscape is the best for checking duplicate content but it is paid.

 

It does allow dublicate content and dublicate links if set up to allow dublicates.
And that's what im trying to do - find and remove, as you say

Yes, Descriptions too, actually thats the main thing. There can be few same links in directory, no harm done.
But if there dublicate descriptions, thats worst as google doesnt love that.

I need to check for dublicate content within my own directory.

Im not sure Copyscape will check within the site, even if i buy credits, i did not seen such option... maybe i missed...

 

Of course Copyscape has nothing to do with duplicate domains in database
it just these 4 never bother to read all posts and to grasp what you are trying to do.



fastreplies

 

Copyscape.com would be the way to go