Jump to content

How to change order of 2 fields at the same time on mysql?


alapimba

Recommended Posts

Hello

 

I have one mySQL table that has lets say 3 columns (id, name, sort_number)

 

The sort number is used to sort name has i don't want to sort them alphabetic or something like that.

Now my question is.. how to change order... lets say change 3 with 4 and 4 with 3...

Maybe i'm explaining my question the wrong way... basicly what i need is to sort one table "by hand" theres nothing logic on that.

 

How can i do that? I'm really lost with this.

 

THanks

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.