Listing MySQL table in reverse

[Phaelon]

Hi all,


I have a MySQL table with the field 'number'.
When I SELECT * from that field, I get a return for the rows of 'number' in the order 1, 2, 3, 4, etc...
 

SELECT * FROM products;

Is there a way where I can get a return in the reverse order, so highest to lowest (4, 3, 2, 1, etc...)?

[Barand]

SELECT .... ORDER BY whatever DESC

[Phaelon]

Thanks, but it didn't work.

 

 

SELECT * FROM products DESC;

 

 

 

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC' at line 1

[Barand]

Then I suggest you re-read my post

[Phaelon]

Wow! Yeah how did that happen!!

 

OK I tried it, it works. You are truly awesome!

 

Thank you.