mysql> select geoname_id from alternames where match(name) against('+copan*' in boolean mode) group by geoname_id order by geoname_id;
+------------+
| geoname_id |
+------------+
|     680926 | 
|     705048 | 
|    1123168 | 
|    1132168 | 
|    1137376 | 
|    1143344 | 
|    1144896 | 
|    1144897 | 
|    1144898 | 
|    1144921 | 
|    1147191 | 
|    1350000 | 
|    1424747 | 
|    1447417 | 
|    1447421 | 
|    1448775 | 
|    1456560 | 
|    1456628 | 
|    1457203 | 
|    1462039 | 
|    1467739 | 
|    1470637 | 
|    1472468 | 
|    1472538 | 
|    1474424 | 
|    1476855 | 
|    3185868 | 
|    3377791 | 
|    3530254 | 
|    3584988 | 
|    3586898 | 
|    3597202 | 
|    3597956 | 
|    3601494 | 
|    3601519 | 
|    3603241 | 
|    3612015 | 
|    3612016 | 
|    3612017 | 
|    3612018 | 
|    3613211 | 
|    3613214 | 
|    3613220 | 
|    3613221 | 
|    3613226 | 
|    3613228 | 
|    3613229 | 
|    3893670 | 
|    3905287 | 
|    3919160 | 
|    3919161 | 
|    4012917 | 
+------------+
52 rows in set (0.01 sec)