应用于字符串的mysql字母顺序 [英] mysql alphabetical order applied to a string

问题描述

在 mysql 中，这是按字母顺序排列字符串的一种方式吗?我正在寻找一个能做到这一点的函数:

Is it a way in mysql to alphabetically ordering a string ? I am looking for a function who does that :

select alphabeticallyorder('cba')

会回来的

'abc'

推荐答案

像这样的查询应该返回您需要的值.我知道这不是一个很好的查询，而且您还需要一个数字表，其中填充了数字:

A query like this should return the values that you need. I know it's not a nice query, and you also need a numbers table, filled with numbers:

SELECT col, GROUP_CONCAT(SUBSTRING(col, n, 1)
                         ORDER BY SUBSTRING(col, n, 1)
                         SEPARATOR '') AS ordered_col
FROM
  tablename INNER JOIN numbers
  ON LENGTH(tablename.col)>=numbers.n
GROUP BY
  id, col

也只有在 LENGTH(col)=CHAR_LENGTH(col) 时才有效.请参阅 fiddle 此处.

Also it will work only if LENGTH(col)=CHAR_LENGTH(col). Please see fiddle here.

这篇关于应用于字符串的mysql字母顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！