Is it possible to resort the rows in a table like in a query where using ORDER BY, but have to new sort order stored in the table structure?
If you use PhpMyAdmin (latest version), follow these steps:
1. Select your table by clicking on the left.
2. Choose 'Operations' from the top.
3. And the first bullet, you will find something that says: Alter table by _____ (singly).
4. Just choose the appropriate field and click 'Go'
Ofcourse this feature will be more robust, if you constructed your own query.
-- Think to think more, work to work more. __________________________________________ Meet the guy at http://www.meetRajesh.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
