How to query for 25 records before and 25 records after a record alphabetically

[Jeremy March]

I have an alphabetic list of records in a table and I want to display the 25 
previous and 25 next records before and after a selected record.  This would 
be easy if "before" and "after" meant sorted by id number, but I need it 
sorted alphabetically.  Does anyone know a good way to do this?

Thanks,
Jeremy March
_________________________________________________________________
Never get a busy signal because you are always connected  with high-speed 
Internet access. Click here to comparison-shop providers.  
https://broadband.msn.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]