I have a MySQL point inside a MySQL polygon. I need to know how close this point is to the boundary of the polygon. According to other related posts ST_DISTANCE only works with points outside of a polygon.

I’d like to do this in a MySQL (8.0+) query. But if that’s not possible, I can write Java code to it. I just need help on the algorithm.

I’ve seen this problem asked several times. But I haven’t found any MySQL or Java answer or a response that definitively says it can’t be done.