mysql - 如何通过zerofill进行mysql分组？

Question

SELECT count(w.c1) AS count
     , w.c1 AS color
FROM
  data w
GROUP BY
  w.c1
ORDER BY
  w.id DESC
LIMIT
  50000;

我想知道，是否有任何类型的mysql查询可以按zerofill值分组，我将c1中的所有值都作为rgb代码'0002500034'(r=000/g= 250/b=034)，查询后显示为000250034->250034

Answer 1

LPAD MySQL 函数怎么样？ LPAD(str, len, padstr)

SELECT count(w.c1) AS count
 , LPAD(w.c1, 9, '0')  AS color
FROM
  data w
GROUP BY
  w.c1
ORDER BY
  w.id DESC
LIMIT
  50000;

您还可以将列类型转换为 CHAR(9)。