How to sort alphabetically in Ruby on Rails excluding something in a word?

Question

MySQL

Let's say there is an Address model, with name fields.
And there are such records:
Belova st .
Aleksey
st .

Answer 1

Ideally, put the address type in a separate field, but if you now need to organize a report in a quick way, you can use the power of postgresql (do you use it?) This method will work slowly with large amounts of data. Would recommend to reconsider such approach to saving addresses. :)