mercredi 23 décembre 2015

how to order by a substring regexp?

I have a string column that is something like 'foo.bar.baz123' and I would like to order on the integer at the end of that string so.. In postgres, I can do this with:

ORDER BY SUBSTRING(column FROM '(\d+)$')::integer

But how do you do it in sqlite?

Aucun commentaire:

Enregistrer un commentaire