我已经搜索过,找不到完全适合我需求的解决方案。我有一个需要修改的mySQL命令,但是我像查克一样被卡住。以下代码按街道名称为单位,但我也需要它以#之后进行排序。这是我拥有的代码:
SELECT * from property_details
ORDER BY SUBSTR(LTRIM(address), LOCATE(' ',LTRIM(address))) ASC
这样做是这样做的:
320 Booken Pine
803 E. Cordy Ct.
2046 Last Fine Court
2000 Last Fine Court
2019 Last Fine Court
27-A Persons Alley
27-B Persons Alley
我需要这样做:
320 Booken Pine
803 E. Cordy Ct.
2000 Last Fine Court
2019 Last Fine Court
2046 Last Fine Court
27-A Persons Alley
27-B Persons Alley
任何帮助都非常感谢。非常感谢您的高级。
您需要第二个ORDER BY
标准,用数字按相同的街道名称对行进行排序。
SELECT * from property_details
ORDER BY SUBSTR(LTRIM(address), LOCATE(' ',LTRIM(address))) ASC,
LEFT(address, LOCATE(' ',LTRIM(address)) ASC