Here is a way to return results from a table in a custom order
select id from products where id in (4,5,6,7,8,9) order by field(id,4,7,6,5,9,8)
MySQL custom sort order
Leave a Reply
You must be logged in to post a comment.
Here is a way to return results from a table in a custom order
select id from products where id in (4,5,6,7,8,9) order by field(id,4,7,6,5,9,8)
You must be logged in to post a comment.