sqlite能自然排序吗?例如,
原文链接:https://www.f2er.com/sqlite/197667.htmlCREATE TABLE animals ( id INTEGER NOT NULL PRIMARY KEY,name TEXT NOT NULL ); INSERT INTO animals (name) VALUES ('Monkey'); INSERT INTO animals (name) VALUES ('manatee'); SELECT name FROM animals ORDER BY name; name ---------- Monkey manatee
我希望自然地对结果进行分类(即海牛,猴子). sqlite没有这样排序的选项吗?我对大量数据进行了排序,如果sqlite无法自然排序,我认为解决方案是回到Postgresql或MysqL.