需要帮助Mysql查询使用Group By匹配列值开始的前10个字符，并将它们分组在相同的名称下 - needed help for Mysql query to using Group By for matching first 10 characters in start of column value and group them under same name

needed help for Mysql query to using Group By for matching first 10 characters in start of column value and group them under same name

我需要帮助Mysql查询使用组By匹配列值开始的前10个字符，如column, column1, column data，…我想要这个和show一样，组叫做column。我正在尝试以下查询，但似乎缺少一些记录。

SELECT id, name 
FROM acx_projects 
WHERE type='projecttype' AND state='Live' 
GROUP BY Left(name, 10);

谢谢

试试这个

SELECT id, name, Left(name, 10) as sub FROM acx_projects wheretype='projecttype' AND state='Live' GROUP BY 3;

尝试提取字段中的前10个字符，然后使用子查询按此字段分组

select * from (
   SELECT 
      Left(name, 10) as FirtsChars, 
      id,  name 
   FROM acx_projects 
   where 
      type='projecttype' AND 
      state='Live'
) as Data 
Group by FirstChars;