On 16 May, 09:55, Aahz <juno10...@hotmail.com> wrote:
> select number,name,age,address from people
> where number in (88,4,2,6,8,1,166,33)
>
> How I make this to have order by exact numbers as in query. I want
> result to be ordered like this:
>
> 88
> 4
> 2
> 6
> 8
> 1
> 166
> 33
>
> and not
>
> 1
> 2
> 4
> .....etc
>
> and not by name or anything else
>
> How to do this ? Thank you

SELECT
`number`,
`name`,
`age`,
`address`
FROM `people`
WHERE `number` IN (88,4,2,6,8,1,166,33)
ORDER BY FIND_IN_SET(`number`,'88,4,2,6,8,1,166,33')