Inserting Lat/Long spatial extensions into MySQL

Question

I'm wanting to put polygons into a MySQL database and then with PHP be able to query if a latitude/longitiude point is inside the polygon.

Any pointers here. Never done anything like this yet.

Answer 1

MySQL supports Spacial columns and functions using an extension which is quite often installed by default.

MySQL Reference for spacial features

How to use MySQL Spacial extension