Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > mysql的排序问题

mysql的排序问题

WBOY
Release： 2016-06-23 14:38:14
Original
794 people have browsed it

我用order by time排序一个表格
可是排出来的结果是 0 10 100 1000 1010 1020 110 120...这样的
我想让排序结果是从小到大排 请问能实现么?
求指教~


回复讨论(解决方案)

你的 time 字段是字符型的？
order by time+0
就可以了

time 是什么类型

把time转换成整型

order by CAST(time AS UNSIGNED) 

就可以了

Related labels：
mysql的排序问题
source：php.cn
Previous article：请教 要求x包含y,x按y排序 Next article：将参数带入网页
Statement of this Website
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
Latest Articles by Author
Latest Issues
The execution order of VueJS scheduling functions causes problems I'm trying to display a list of announcements (retrieved from API) on a page. I'm using a ...
From 2024-04-06 10:37:58
0
1
385
How to insert multiple rows in MySQL table and return new IDs? Normally I can insert a row in a MySQL table and get the last_insert_id. But now, I want t...
From 2024-04-06 10:03:44
0
2
294
There is an error with npx create-react-app command, how do I fix it? I've been trying to create a new React app using the 'npxcreate-react-app' command but it ...
From 2024-04-05 14:42:18
0
1
3511
How to update a React component's dependencies in useEffect without creating an infinite loop I have a React component where I need to wait for a stored value (member) to update and th...
From 2024-04-05 14:31:46
0
1
1383
How to solve the problem of creating a React application? [closed] Actually I added npxcreate-react-appmy-app so while creating my React app I got an error i...
From 2024-04-05 12:46:17
0
1
412
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template