changing position / re-arranging records in phpmyadmin

Question

i have this database

id user_id auction_id no_of_bids bid_value timestamp 110 236 435 3 6 2015-11-10 12:40:21 111 238 435 4 6 2015-11-10 12:46:33

i want to re arrange the order of these records, for example in the current situation, i want 238 to come before 236, is there a query to execute the said operation? i know about changing column orders, but i believe records can not be re arranged like that. is there a way or query where i can re arrange the records and let 238 come before 236, or, be at the top of records?

well that's pretty obvious, i was looking for a query to perform this action in my code. PHP code. — Shahsays
– Shahsays, Commented Nov 10, 2015 at 13:11

Gordon Linoff · Accepted Answer · 2015-11-10 13:11:07Z

1

You can use order by:

select t.* from t order by (t.user_id = 238) desc;

This will put 238 first.

answered Nov 10, 2015 at 13:11

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Strawberry Over a year ago

(or perhaps just order by user_id desc - the question isn't really clear enough. Anyway @FaizanShah, either way, it's pretty obvious too, isn't it ;-) )

Collectives™ on Stack Overflow

changing position / re-arranging records in phpmyadmin

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related