the ideea is that i have a table that has a name field ... and i will like to select the similar entries to try and eliminate the duplicates. The thing is i will love to find a way to not limit to exact match ...
ex : title_name similar to : titlename, TitleName, title name1

I can imagine a way to do this ... but i would like to ask you guys wich will be the best/quickest/less use of resurce way. I am tring to do this in as few sql querys as possible.

Thank you so much

Originally Posted by solomongaby

the ideea is that i have a table that has a name field ... and i will like to select the similar entries to try and eliminate the duplicates. The thing is i will love to find a way to not limit to exact match ...
ex : title_name similar to : titlename, TitleName, title name1

I can imagine a way to do this ... but i would like to ask you guys wich will be the best/quickest/less use of resurce way. I am tring to do this in as few sql querys as possible.

Thank you so much

I might not understand perfectly but here is what I'd do:

PHP Code:

$res = mysql_query("SELECT * FROM table_name WHERE field_name LIKE '%$query%'");
if (mysql_num_rows($res) > '0') {
for ($i=0;$i<mysql_num_rows($res);$i++) {
$title = mysql_result($res,$i,"title_field";
echo ("$title <br />");
}
} 


I'm sure someone else can modify my logic to make it more efficient, but that should work.

the problem with you're solution ( that was my first ideea too ) is that i have to run the query for each row ... to find out wich has duplicates and wich don't

Why don't you set the field to unique?