如何将多列合为一体并使用自定义字符串设置格式? [英] How to combine multiple columns as one and format with custom strings?

问题描述

SELECT id, <X> AS name FROM `table`

基本上<X>是
的组合 姓氏+'，'+姓氏

Basically <X> is a combination of
lastname + ', ' + firstname

示例将是

   id | name        |
   2  | Smith, Bob  |
   3  | Jones, Susy |

这只是一个例子，我真的不想合并这么简单的名称.

This is just an example, I don't really want to combine names so simple.

推荐答案

如果要连接许多字段，还可以考虑 CONCAT_WS() 函数，其中第一个参数是其余参数的分隔符，并在要串联的字符串之间添加:

If you are going to concatenate many fields, you could also consider the CONCAT_WS() function, where the first argument is the separator for the rest of the arguments, which is added between the strings to be concatenated:

SELECT id, 
       CONCAT_WS(',', field_1, field_2, field_3, field_4) list
FROM   `table`;

这篇关于如何将多列合为一体并使用自定义字符串设置格式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！