mysql - 如何 'Create a table based on a query and delete from first 3 characters to the right'

Question

我有一个简单的查询:

select pcode, description from outerb where pcode like '123%'

这是一个 fiddle 链接，向您展示我到达的位置:

https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=bf44b07918374985074084552e7b7005

如何根据上面的查询创建一个新表，但删除第三个字符右侧的所有字符？

这是我的预期输出

pcode   description 
123        TEST     
123        TEST    

Answer 1

我认为您需要 left() 函数:

select left(pcode, 3) as pcode, description, size
from table1;