really it is a great article, i was looking for like.

But i have one problem with my table and i was stuck in spatial query for it.

description of my table is like this

field – type

—————-

id – int (10)

property – geometry

in property field we stored latitude and longitudes as POINT type. (select astext(property) from mytable; will return POINT(12.000 77.0000))

how to apply haversine formula as you mentioned on mytable?

do i need to extract lat lon values first and apply your query after? (i tried select X(coordinates),Y(coordinates) from mytable; but ended up with unknown column coordinates error) or is there any direct way to apply haversine formula on mytable?

thank you

Hey, did you found any answers about this? I have a similar problem http://laravel.io/forum/09-16-2015-select-raw-inside-eager-loa...