sarah posted

how to concat two field in Mysql


SELECT customers_firstname+' '+customers_lastname FROM `customers`

result:

customers_firstname+' '+customers_lastname
0
0
0

so i thought here '+' means plus not join two field

so i use


SELECT customers_firstname. ' '.customers_lastname FROM `customers`

result:
got Error

so how to concat two field in mysql ?

you can use CONCAT


select CONCAT(customers_firstname,'  ',customers_lastname) from `customers`

or concat with separator :CONCAT_WS


select CONCAT_WS('  ',,customers_firstname,customers_lastname) from `customers`

both give same output

simply use concat function of Mysql


select concat(customers_firstname,' ',customers_lastname) from `customers`

Post Answer

OMG! You need to Login / Register to Post Answer

[code] Bold LE LP LD LW LDR WAR INF DAN SUC FYI h2 h3 italic