PHP Technical Blog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment