sql - mysql order by, skip non-alphanumerics -


in doing mysql sort by title, following results:

#314: basket case $1.2 billion scam: ft. frauderdale (dis)members - m - ...and makes 3 3:10 yuma (2007) 

how ignore special characters, results sorted follows:

$1.2 billion scam: ft. frauderdale 3:10 yuma (2007) #314: basket case ...and makes 3 (dis)members - m - 

nested replaces achieve column without special char, ugly like

select replace(replace(field, '.', ''), '#', '') fld table order fld 

Comments