[SOLVED] CONCAT function with separator?

[Daveyboy]

I looked at the Mysql manual but cant find a way to seperate two strings with a space. For example,
when i run this query in php it comes out "firstnamelastname". I want it to be "firstname lastname".

$query = "SELECT CONCAT(firstname,lastname) FROM info WHERE id=$id";

[printf]

Just add a space param between the columns you want to join together.


[code]$query = "SELECT CONCAT(firstname, ' ', lastname) AS full_name FROM info WHERE id = " . $id;[/code]


printf

[Daveyboy]

thanks!

[artacus]

LOL. With a name like printf, how could he NOT know how to format strings?