Mysql - How to sample points in a square of terrain by coordinates?

Question

MySQL

Hello!
Tell me please. There is a table of points with coordinates in the lng and lat fields.
You need to select a list of points in a certain rectangle of the area. those. we have the coordinates of the upper left corner and the lower right corner.
If there are already ready requests, I will be very grateful.
Thanks in advance!

Answer 1

And what is the difficulty to write two BETWEEN in WHERE?

Answer 2

Yes, correct me if I'm wrong, but lng and lat are conditionally a coordinate grid. Accordingly ,
where x1,y1,x2,y2 are the coordinates of the rectangle, and   x  and   y are the coordinates of the point.