[SOLVED] select closest to?

[Azu]

Hi, could somebody please tell me how to do this?

 

Something like

 

select * from row where x,y,z is closest to 1,2,3

 

I have a table with x y z coordinates in it and I want to select select from there whichever one is closest..

[Wildbug]

Pythagorean theorem.

 

SELECT *,
SQRT(POW(x-xcol,2) + POW(y-ycol,2) + POW(z-zcol,2)) AS distance
FROM table
ORDER BY distance
LIMIT 1;

[Azu]

Thanks you're a genius it works perfectly.