List:General Discussion« Previous MessageNext Message »
From:Rajesh Kumar Date:August 19 2003 5:53pm
Subject:Re: "hard" sort table order
View as plain text  
anders thoresson unknowingly asked us:
> 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 

Think to think more, work to work more.
Meet the guy at

"hard" sort table orderanders thoresson19 Aug
  • Re: "hard" sort table orderYves Goergen19 Aug
  • Re: "hard" sort table orderDan Nelson19 Aug
  • Re: "hard" sort table orderRajesh Kumar19 Aug