> 
> **Possible Duplicate:**  
> 
> [How to get First and Last record from a sql query?](https://stackoverflow.com/questions/1485391/how-to-get-first-and-last-record-from-a-sql-query) 
> 
> 
> 

I have words sorted by alphabetical order in the mysql db. How can I get the first and last words for each letter of the alphabet.

so let's say there are the following words in the db:

air
airplane
awol
around

I want to concatenate the first and last words of the alphabet (so in this case air-around). I want to get the first and last word starting with a particular letter sorted by alphabet.