UP3UbmmU

1SELECT gid, ST_AsGeoJson(geom)
2 FROM table
3 WHERE geom && ST_MakeBox2D(ST_MakePoint(), ST_MakePoint())::geometry;
4	
5SELECT gid, ST_AsGeoJson(geom)
6FROM table
7WHERE MBRIntersects(ST_PolygonFromText(), ST_SRID(geom, 0));
8	
9CREATE TABLE IF NOT EXISTS table (
10    gid INT PRIMARY KEY AUTO_INCREMENT
11);
12ALTER TABLE table
13ADD COLUMN geom MultiPolygon NOT NULL SRID 4326,
14ADD SPATIAL INDEX(geom);