php - 在 MySQL 中合并结果

Question

我有这个问题:

$query = 
         "
         SELECT
           detail_firstN AS firstname,
           detail_lastN AS lastname
         FROM users
         WHERE
           users_id = :users_id
         ";

结果会是这样的:

Array
(
    [firstname] => John
    [lastname] => Doe
)

在 MySQL 中有什么方法可以将结果合并为只有这个输出吗？

Array
(
    [name] => John Doe
)

Answer 1

使用CONCAT

SELECT CONCAT(detail_firstN, ' ', detail_lastN) AS Name
FROM   users
WHERE  users_id = :users_id

• CONCAT

或CONCAT_WS

SELECT CONCAT_WS(' ', detail_firstN, detail_lastN) AS Name
FROM   users
WHERE  users_id = :users_id

• CONCAT_WS

更新 1

• See SQLFiddle Demo