如何在MySQL中订购1,2,3而不是1、10、11、12

本文介绍了如何在MySQL中订购1,2,3而不是1、10、11、12的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

以下代码按id的1、10、11、12的顺序输出.

The following code outputs in order of 1, 10, 11, 12 of id.

我想使其成为1,2,3,4 ...

I want to make it 1,2,3,4...

任何人都可以告诉我该怎么做.

Could anyone tell me what I should do please.

$Q = $this->db->query('SELECT P.*, C.Name AS CatName FROM products AS P LEFT JOIN categories C ON C.id = P.category_id');

提前谢谢.

推荐答案

首先，在末尾添加order by子句:

First, add an order by clause at the end:

ORDER BY category_id

如果category_id是字符串，则必须将其视为整数.有几种方法可以做到这一点.我通常加一个零.您也可以投射它.

If category_id is a string, then you must treat it like an integer. There are a few ways to do this. I usually add a zero. You can also cast it.

ORDER BY category_id + 0