擅长:python、mysql、java
<p>在PostgreSQL中,我发现这是一个很好的开始这种排序的方法:</p>
<pre><code>SELECT title
FROM albums
ORDER BY
CASE
WHEN title ~* '^The ' THEN substring(title from 5)
WHEN title ~* '^An ' THEN substring(title from 4)
WHEN title ~* '^A ' THEN substring(title from 3)
ELSE title
END asc;
</code></pre>
<p>我猜MySQL也有类似的beasties。在</p>