I have a text column in my DB that stores a list of house names and numbers and when i order by ASC it outputs like this:

```
"Name No 1"
"Name No 12"
"Name No 14"
"Name No 5"
"Name No 7"

```

Is there an easy way of ordering it in the actual order like:

```
"Name No 1"
"Name No 5"
"Name no 7"
"Name No 12"
"Name No 14"

```

If it was my site i would have had two columns one for name, and another for number but i cannot change it as it's a live site