mysql - 选择 MIN/MAX 列经纬度

Question

我有一个看起来像这样的专栏

如何获得最小值和最大值？

这是期望值，右侧是排序后的值

Answer 1

Select membername From
(Select membername,
substring_index ( membername,',',1)+substring_index ( membername,',',-1) as total
From Table1) T1
Inner Join 
(
Select Max(total) total1,Min(total) total2 From (
SELECT membername,
       substring_index ( membername,',',1)+substring_index ( membername,',',-1) as total
From Table1)T) T2
ON T1.total=T2.total1
OR T1.total=T2.total2

现场演示

http://sqlfiddle.com/#!9/5f6410/1