MySQL GIS - Selecting shape that contains point

Databases
1

So I have a table of points and a table of polygons (geometry types).

In my php, I will have a given point and need to find the corresponding shape. So logically doing something like;


SELECT hb.`OGR_FID`, hb.`SHAPE`
FROM boundaries hb
WHERE ST_Within(Point(43.670913, -79.346739), hb.`SHAPE`);

Should yield the shape ID and Shape that contains the point. It however returns no matches.

Any idea what I’m doing wrong here?

MySQL 5.6.5

2

Well, found the solution myself. Seems I had the lat/lng backwords. Point() requires the parameters Point(lng, lat) :slight_smile: