How to make a selection on the server of geographic features for a given area of ​​the map?

Question

PHP

It is necessary to implement the functionality of searching on the map for a given scope. For example, for a selected polygon or the entire map visibility area for different scales.
Example www.domofond.ru/karta/?SearchType=ForSale&RegionId=30
Is it possible to somehow limit the selection from the database for these areas?

Answer 1

https://www.percona.com/blog/2013/10/21/using-the-...
they write that to work with a bounding rectangle, contains is enough instead of st_contains.
Don't forget to read up on supported indexes and build them (selecting without a tree will be difficult).