SEO

#1 (**permalink**) 02-28-2008, 09:50 AM

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

#2 (**permalink**) 02-28-2008, 09:50 AM

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')

#3 (**permalink**) 02-28-2008, 09:50 AM

Thank you Captain !

Captain Paralytic je napisao:
> 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')

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

help with query