use "http://thinkphp.ro/apps/php-hacks/distance/v2/vincenty.distance.xml" as geo.distance; select * from geo.distance where place1="bucharest" and place2="london"