mysql won't order by INT

Question

I have set up a table with a column called order. I made sure it is set as INT. I can't seem to get the results to list in order. I currently have 5 rows with numbers 1-5 in a random order in those rows. However, I can't get those rows to go in order. Maybe I am doing this completely wrong, as I am new to MySql. Here is my query

SELECT * FROM faq ORDER BY 'order'

see this post it explains why http://stackoverflow.com/questions/2889871/how-do-i-escape-reserved-words-used-as-column-names-mysql-create-table — Bearcat9425, Jun 27 '13 at 19:24

score 3 · Accepted Answer · edited Jun 27 '13 at 19:24

3

You should use the back-tick, not the quote:

SELECT * FROM faq ORDER BY `order`

edited Jun 27 '13 at 19:24

Travesty3

14,351
6
61
98

answered Jun 27 '13 at 19:23

Jehad Keriaki

545
5
10

score 3 · Answer 2 · answered Jun 27 '13 at 19:23

3

You need to use backticks in mysql, not quotes.

SELECT * FROM faq ORDER BY `order`

answered Jun 27 '13 at 19:23

Robbert

6,481
5
35
61

score 2 · Answer 3 · answered Jun 27 '13 at 19:23

2

You need:

SELECT * FROM faq ORDER BY `order`

You're using single-quotes in your example. MySQL uses backticks for wrapping table names, field names, etc. You need to use backticks in this case because order is a reserved word in MySQL.

answered Jun 27 '13 at 19:23

WWW

9,734
1
29
33

viraptor · Answer 4 · 2013-06-27T19:36:08.587

1

You're quoting 'order' like a string, so the sorting will be done by the value order itself (a string) rather than by the column. Change them to backticks instead.

edited Jun 27 '13 at 19:36

answered Jun 27 '13 at 19:23

viraptor

33,322
10
107
191

2

Dropping them completely here isn't an option since `order` is a reserved word. – Dave S. Jun 27 '13 at 19:24

score 0 · Answer 5 · answered Jun 28 '13 at 06:26

0

You should use backtik not quotes:

SELECT * FROM faq ORDER BY `order`;

Refer: http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

answered Jun 28 '13 at 06:26

Sathish D

4,854
31
44

mysql won't order by INT

5 Answers5