If I understand the manual correctly when I do a "select blah from blah where blah = blah order by blah limit 10" Mysql finds the first 10 matching records and then sorts those records. How do I have it first sort the database and then take the first 10 records? Thanks for your help, Mat ____________________ Your mouse has moved. Windows must be restarted for the change to take effect. Reboot now? [ OK ]