Re: MySQL syntax error - don't get it!

[Gregary Boyles]

In MySQL Workbench...

This works:

SELECT * FROM millhouse_db.sponsors WHERE type='funding' ORDER BY business_name;

This fails with a syntax error:

SELECT * FROM millhouse_db.sponsors WHERE type='funding' ORDER BY rank;

Why?

business_name is a varchar(...)

rank is an int(10)

So why can't I sort by an integer column?