MGRS coordinates

SELECT geopoint.userenteredcoord, concat( upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1)),right(geopoint.userenteredcoord,7))

FROM geopoint

WHERE geopoint.coordrefsys = 'MGRS' AND

binary left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1) <> upper(left(geopoint.userenteredcoord, locate('|', geopoint.userenteredcoord) -1))

ORDER BY length(geopoint.userenteredcoord)

---

SELECT user_entered_mgrs

FROM geopoint

WHERE coordrefsys = 'MGRS' AND user_entered_mgrs LIKE '% %'

ORDER BY user_entered_mgrs ASC