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

[Henrique Garcia]

Hi, Gregary!
How are you?

Which version are you currently using?

In versions 8.0 and later, the term RANK is reserved; consequently, the parser interprets "rank" as part of the SQL language rather than as a column name.

Try using this format:
SELECT *
FROM millhouse_db.sponsors
WHERE type = 'funding'
ORDER BY `rank`;