mysql order by，跳过非字母数字

Question

在执行mysql SORT BY标题时，我得到了以下结果：

#314: Basket Case
$1.2 Billion Scam: Ft. Frauderdale
(Dis)Members Only
- M -
...And Something Makes 3
3:10 to Yuma (2007)

我如何忽略特殊字符，这样结果将按如下方式排序：

$1.2 Billion Scam: Ft. Frauderdale
3:10 to Yuma (2007)
#314: Basket Case
...And Something Makes 3
(Dis)Members Only
- M -

Answer 1

嵌套替换以实现没有特殊字符的列，类似于

SELECT REPLACE(REPLACE(field, '.', ''), '#', '') AS fld
FROM table
ORDER BY fld