Tuesday, November 8, 2011

Mysql query float value in where condition is giving empty result set for google latitue and longitude values

Mysql query float value in where condition is giving empty result set for google latitue and longitude values

SELECT lat, lon FROM googletable WHERE ABS(TRIM(lat)) = ABS(TRIM(51.5137));

No comments:

Post a Comment