How to insert at specified row of table

[Yakhunter]

I've checked my reference books, and many sites including this one, and can't find a way to insert a row at the location I choose. I don't want it in alphabetical order, or anything, but I do want to control where the data can be placed. I'm sure others have had the same problem. Any suggestions?

[Houdini]

This might be just what you are wanting to do but you don't use INSERT you use ALTER

Put a new field after another field

ALTER TABLE `tablename` ADD `newfield` VARCHAR( 10 ) NOT NULL AFTER `fieldname` ;

Put a new field at beginning of the table

ALTER TABLE `tablename` ADD `newfield` TINYINT( 2 ) NOT NULL FIRST ;

Put a new field at the end of the table

ALTER TABLE `tablename` ADD `newfield` VARCHAR( 7 ) NOT NULL ;

That should do what I believe you are asking about, as you can see if you were looking to insert then that might be why you could find the way to do it, unless you want to do something different.

[Lars_Berg]

... but I do want to control where the data can be placed.

You can't. What are you trying to accomplish?

[Yakhunter]

Well, what I'm actually trying to do is set up a window where a user can insert titles in the order they wish to have them displayed. This is for a bulletin page. When the bulletin page is to be updated some of the entrys must be taken out, and new ones put back in. However, when a new one is entered I want to know if it can be placed in the middle of the table without using an order?
Does this make better sense now?

[laserlight]

However, when a new one is entered I want to know if it can be placed in the middle of the table without using an order?

There must be a column to use in ordering the result set.

[Yakhunter]

Yes, I wish to use my title column in order to do the inserting, but can I determine where in the column to put the data, or must it be number of alpha ordered?