结合的结果在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

Answer 2

试试这个代码

<?PHP 

function combine_result($array,$out_key = "name") // Deafult output key is [name] 
{ 
    if(is_array($array)) 
    { 
     $vals = array_values($array); 
     $out = implode(" ",$vals); 
     return array($out_key=>$out); 
    } 
} 


$array = array(
       "firstname" => "John", 
       "lastname" => "Doe"); 


print_r(combine_result($array)); // Array ([name] => John Doe) 


?>