Moving a field up

I have a column called alphabet, with the fields B, A, C, D:

alphabet
--------
B
A
C
D


I am wanting to know how I can go about moving A up to where B is, so:

Alphabet
--------
A
B
C
D

There are other fields from other columns on this same line:

A | Active | Always


This procedure would be similar to:
ALTER TABLE (table) CHANGE COLUMN (column) (new column name) (type) AFTER (column);, but for a field instead of a column.

no it wouldn't be similar to that at all, you would use an ORDER BY in your query.

Cool, so do you know how it can be done?

SELECT something FROM table_name ORDER BY `alphabet`

Ah.. I am wanting to make it so they will be alphabetical when I select *.

So change my something to * ... the order by is what will make the result set returned alphabetical.