mysql example for order by where

Example: mysql order

SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC