Home

Monday, April 7, 2014

Mysql order by specific ID values

1). select * from table_name order by case when id=8 then 0 else id end

2). select * from table_name order by field(8,id) desc,id

No comments:

Post a Comment

rathoddhirendra.blogspot.com-Google pagerank and Worth