执行以下查询:
SELECT title FROM table ORDER BY title
给我:
"Hello" "Zebra" Apple Beta Cactus
我如何通过第一个字母字符排序,以获得:
Apple Beta Cactus "Hello" "Zebra"
?
SELECT title FROM table ORDER BY TRIM(BOTH '"' FROM title);