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