How to use similar_text with a MySQL query?

[orgzchaos]

This code takes and deletes exact duplicates from the database.

 

<?php
$con = mysql_connect("myhost","myacc","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("mydb", $con);
$runme="DELETE bad_rows.* from wp_posts as bad_rows inner join ( select post_title, MIN(id) as min_id from wp_posts group by post_title having count(*) > 1 ) as good_rows on good_rows.post_title = bad_rows.post_title and good_rows.min_id <> bad_rows.id";
$result=mysql_query($runme);
mysql_close($con);
?>

 

Now instead I am looking to use similar_text functionality to check for duplicates in the database and delete every match besides the one with the lowest ID ( the original ). What would be the simplest and resource efficient way to do that? Samples would help a lot.

 

Thanks