All simular posts list in dashboard

  • Gustav

    (@4ever16)


    7 years, 9 months ago

    Im using Delete Duplicated Posts plugin but it searches post titles case sensetive.

    Im trying to find a plugin or something which will show a big list of all simular posts.

    Example.
    Post 1
    Post-1
    Post1

    The plugin or the function should list all these posts in a list because they are very simular one to antother.

    So is there a plugin for this which shows this in the dashboard?

    • This topic was modified 7 years, 9 months ago by Gustav.
Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    7 years, 9 months ago

    Sorry, I’m unaware of any such plugin. Writing a SQL query to do this isn’t too complicated. You could make a custom page template to run the query. Add a new page based on the template. Request the new page to execute the query. A very minimal example (untested):

    <?php
// Template Name: Similar Posts
get_header();
global $wpdb;
$posts = $wpdb->get_results("SELECT post_title FROM $wpdb->posts
	WHERE post_title COLLATE utf8_general_ci LIKE 'Post%1'");
?>
<h2>Similar Posts</h2>
<pre>
<?php
print_r( $posts );
echo '</pre>';
get_footer();

    Here the LIKE criteria is hardcoded. You can manually change it as required, or make the template into a form that accepts LIKE criteria and uses it in the SQL. Wildcard characters are % to match anything or nothing, and _ to match any 1 character. All other characters must match. The “COLLATE utf8_general_ci” clause makes the query case insensitive.

Viewing 1 replies (of 1 total)

The topic ‘All simular posts list in dashboard’ is closed to new replies.