How to correctly get points with coordinates inside a rectangle?

Question

MySQL

Hello! At me such situation... There are coordinates of two points of a rectangle (left top and right lower corner). It is necessary to get from the database the coordinates that are inside this rectangle.
The following request came up:

SELECT * FROM `coordinates`
WHERE (`lat` BETWEEN '{$latitude2}' AND '{$latitude1}') AND (`lng` BETWEEN '{$longitude1}' AND '{$longitude2}')

Everything works well, until it turns out that the rectangle intersects the zero meridian, or the equator, because, in fact, the request becomes the opposite:

SELECT * FROM `coordinates`
WHERE (`lat` BETWEEN '-7.987931' AND '6.775799') AND (`lng` BETWEEN '172.152671' AND '-168.106551')

Which is no longer correct. Tell me how to solve the problem?

Answer 1

Correct something like this
https://dev.mysql.com/doc/refman/8.0/en/spatial-re...