Sort By diffferent to Order By

[dweb]

Hi all

 

I have the following database table

ID    NAME
1      David
2     John
3     Vicky
4    Rob
5    Suzzie

and I run the following Query

SELECT * FROM `staff` ORDER BY `name` ASC LIMIT 4

Which is cool and works great

 

I want to keep my Query as it is, but I want to sort the output by the ID

 

So it keeps the

ORDER BY `name` ASC

but the actual sorting is by

`id` ASC

Can that be done?

 

Thanx

[Barand]

No.

 

If you want it sorted by id use

... ORDER BY id