Any ideas on this mysql query?

[noj75]

Hi to all on this great site! I am desperate for some help:

PHP Code:

$samesurn = "SELECT * FROM $stb WHERE s_sur IN (SELECT s_sur FROM $stb WHERE s_name='$proname') AND s_name!='$proname' "; 


I am trying to do the above query:

$proname has a list of values in s_sur. I want to query the database to see who else has the same values and then display the results excluding $proname's own results.

This does work but is TERRIBLY slow. Is there another way to do this?

Any help is greatly appreciated. Thank you.