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 
query.

-- 
Think to think more, work to work more.
__________________________________________
Meet the guy at http://www.meetRajesh.com/

Thread
"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