CODEWITHSUNDEEP
mysql
Rich5757
Rich5757

Reputation: 155

Select one field from query with subquery

I am using the MySQL query to find distance between tow zip-codes when lat long is given.

SELECT postcode, ( 3959 * acos( cos( radians( 52.47592 ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( -1.90539 ) ) + sin( radians( 52.47592 ) ) * sin( radians( latitude ) ) ) ) AS distance FROM ukpostcodes  HAVING distance <= 5 ORDER BY distance

it is working fine. But I want only postcode in result. I don't want distance column in result .

How can I achieve it.

Thanks

Upvotes: 0

Views: 33

Answers (1)

H&#233;ctor E
H&#233;ctor E

Reputation: 436

SELECT postcode FROM(
SELECT postcode, ( 3959 * acos( cos( radians( 52.47592 ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( -1.90539 ) ) + sin( radians( 52.47592 ) ) * sin( radians( latitude ) ) ) ) AS distance FROM ukpostcodes  HAVING distance <= 5 ORDER BY distance
) AS tbl

Upvotes: 1

Related Questions