Home  >  Article  >  Backend Development  >  mysql字符串类型的字段排序有关问题

mysql字符串类型的字段排序有关问题

WBOY
WBOYOriginal
2016-06-13 12:39:261276browse

mysql字符串类型的字段排序问题
我有一个字段A,varchar类型。里面有3条数据,经过order by A DESC排序之后,顺序如下2013.03、2013.02、2013.04
请问如何做到时间最新的排在前面?在不修改数据表字段类型的前提下。

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn