blocks|key|1311075|text|听起来你在排序，把这些值看作字符串，而不是数字。你在做什么分类？PHP，还是MySQL？如果不看到实际排序的代码，很难说出出了什么问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1311076|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Sounds like you're sorting by considering those values as strings, instead of as numbers. What's doing the sorting? PHP, or MySQL? Hard to say what's wrong without seeing the code that's actually sorting it.

blocks|key|11813|text|您的字段可能被定义为char/varchar/text/.，即字符串类型，而不是数字类型。在这种情况下，进行词典编纂排序。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|11814|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/string-types.html|1|http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html^0|V|5|0|14|4|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

Your field is probably defined as char/varchar/text/..., i.e. as <a href="http://dev.mysql.com/doc/refman/5.0/en/string-types.html" rel="nofollow noreferrer">string type</a> and not a <a href="http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html" rel="nofollow noreferrer">numeric type</a>. In that case lexicographical sorting performed.

blocks|key|11839|text|排序是将数据视为字符串而不是整数。检查数据库中列的数据类型。如果这是一个数字而不是一个字符串，那么数据将在数据库和排序例程之间的某个位置转换为字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|11840|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The sort is treating your data as strings instead of integers. Check the datatype of your column in the database. If that is a number and not a string, then the data is being converted to strings somewhere between the database and the sort routine.

blocks|key|1562007|text|看起来您正在排序字符串，而不是数字，列的数据类型是什么？正确排序字符串数字的唯一方法是添加前导零，但最好将数据存储在适当的类型中，这样您就不必每次选择数据时都执行此类操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1562008|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

looks like you are sorting strings and not numbers, what is the data type of the column? The only way to sort string numbers properly is to add leading zeros, but it is best to store that data in the proper type, so you don't have to do these sort of manipulations each time you select the data.

blocks|key|1311121|text|如果由于某种原因需要将列保留为字符类型，则可以为排序转换为合适的数字类型。不过，这比仅仅更改列效率要低。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1311122|ORDER+BY+CAST(theColumn+AS+DECIMAL(5,+2))+|code-block|syntax|javascript|1311123|http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html|offset|length|1311124|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|1L|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|T|8|@]|9|@$I|U|J|V|1|W]]|A|$]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|H]]]]

In the event that you need to leave the column as a character type for some reason, you can cast to a suitable numeric type for the ordering. This is less efficient than just changing the column though.

<pre><code>ORDER BY CAST(theColumn AS DECIMAL(5, 2)) 
</code></pre>

<a href="http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html</a>

blocks|key|1562029|text|您的列是文本类型。可以永久更改列类型，也可以在进行排序时对其进行强制转换。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1562030|表alter+(您可能需要一个不同的默认值)|1562031|+ALTER+TABLE+[Table]
MODIFY+COLUMN+[Column]+INTEGER+UNSIGNED+NOT+NULL+DEFAULT+'0';|code-block|syntax|javascript|1562032|或者当你排序的时候|1562033|SELECT+*
++FROM+[Table]
+ORDER+BY+CAST([Column]+as+UNSIGNED+INTEGER)+ASC;|1562034|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Your column is a text type. You can change the column type permanently, or cast it when you do the sort.

Table alter (you may want a different default value)

<pre><code> ALTER TABLE [Table]
MODIFY COLUMN [Column] INTEGER UNSIGNED NOT NULL DEFAULT '0';
</code></pre>

Or cast when you sort

<pre><code>SELECT *
 FROM [Table]
 ORDER BY CAST([Column] as UNSIGNED INTEGER) ASC;
</code></pre>

I have some PHP code which allows me to sort a column into ascending and descending order (upon click of a table row title), which is good. It works perfectly for my D.O.B colum (with date/time field type), but not for a quantity column.

For example, I have quantites of 10, 50, 100, 30 and another 100.

The order seems to be only appreciating the 1st integer, so my sorting of the column ends up in this order: 10, 100, 100, 30, 50... and 50, 30, 100, 100, 10.

This is obviously incorrect as 100 is bigger than 50, therefore both 100 values should appear at the end surely? It seems to me that 100 is only being taken into account as having the '1' value, then it appears before 10 because the system recognises it has another 0.

Is this normal to happen? Is there any way I can solve this problem? Thanks for any help. P.S. I can show code if necessary, but would like to know if this is a common issue by default.

Enhancing an 'ORDER BY' clause to judge condition by more than 1 integer

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一些PHP代码，它允许我将列排序为升序和降序(单击表行标题时)，这是很好的。它非常适合我的D.O.B colum (日期/时间字段类型)，但不适用于数量列。例如，我有10，50,100，30的量化，还有另外的100。顺序似乎只是在欣赏第一个整数，所以我对列的排序是这样的：10、100、100、30、50.和50，30,100,100，10。这显然是不正确的，因为100是大于50，因此，这两个1

问增强“ORDER”子句以判断条件超过1个整数
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问增强“ORDER”子句以判断条件超过1个整数EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问增强“ORDER”子句以判断条件超过1个整数
EN