How to fetch MySQL?

Question

PHP

I have a set of entities in the database. Each entity has coordinates (ordinary numbers, both negative and positive range) x and y, in two fields. It is necessary to select only those that are included in a circle with a center (x, y) and radius R. How to do this through many queries is obvious, but how to do it with one (two or three) queries?

Answer 1

And why do you need a bunch of requests? Only one is needed, but with parameters and a mat. functions.
Pure mathematics, nothing more.

SELECT *
FROM points p
WHERE sqrt(pow(p.x - :x, 2) + pow(p.y - :y, 2)) <= :r -- используем формулу определения расстояния между двумя точками, параметры запроса, которые нужно задать :x, :y, :r.