Moving a field up

[Logician]

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.

[PFMaBiSmAd]

In database terminology, there are rows and there are columns/fields. Columns and fields are the same thing and are interchangeable names that refer to the columns/fields that exist in a table. Think of rows going down the page and columns/fields going across the page.

 

Also, you don't alter your table structure to get your columns/fields or rows to be in a particular order, you do that in your query.

 

I'm guessing that your example actually refers to the value in different rows. To get a result set to be in any particular order, you would use an ORDER BY some_column term in your query.

[Logician]

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

[Logician]

When I:

 

"select * from (table);", they are not alphabetical.

 

I am wanting the table alphabetical when I select *.

[The Little Guy]

select * from table order by alphabet