ORDER BY letters and not numbers of a field
- by Jon
Is there a way to order mysql results by the first letter and ignore numbers? For example, I have a list of addresses:
123 Main Street
456 Second Street
234 Third Street
and I want to order by the street name and ignore the street number. Is there an easy way to do this?