줄내림이 있으면 공백문자로 변경하여 조회 select replace(replace(a , chr(10), ''), chr(13), '') , replace(replace(b , chr(10), ''), chr(13), '') , replace(replace(c , chr(10), ''), chr(13), '') , replace(replace(d , chr(10), ''), chr(13), '') from test
Circle 공간 연산 select * from tt where 1 = 1 and st_contains( ST_Buffer( ST_SetSRID(ST_Point(#{xAxis},#{yAxis}),6645) , #{radius}) ,shape) = true Polygon 공간 연산 select * from tt where 1 = 1 and st_contains( ST_SetSRID(ST_GeomFromText(#{drawWkt}),6645) ,shape) = true