CONCAT MYSQL PROBLEM ??

[papalife]

I want to concat two fields from the orders table delivery_city and delivery_suburb but this does not work

CONCAT_WS(' ',delivery_city, delivery_suburb) ort

The mysql query does not work

Could someone give me an opinion.

Thanks,
Apo

Linkback: https://www.modified-shop.org/forum/index.php?topic=31097.0

[timopaul]

Hey Apo,

try this:

Code: SQL  [Auswählen]

SELECT CONCAT(`delivery_city`, ' ', `delivery_suburb`) AS ort FROM orders

Best regards,
Timo