Ma. Glenda Deloso personal blog site.

The ORDER BY keyword is used to sort the data in a recordset.
The ORDER BY keyword sort the records in ascending order by default.
If you want to sort the records in a descending order, you can use the DESC keyword.

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

Now, I refer to use my SQL Editor. This is the easy way for me to do mysql order by command.
In this case, us usual just type the syntax given above. For example:

select * from registration_form
order by address

The SQL EDITOR for the order by command

And I wiil show you the following results through SELECT * FROM registration_form ORDER BY Address. Which is the results are California, Los Angeles, South Korea.