MySQL SELECT + add a character after value

Question

I need to add a character after a value. For example:

SELECT brand FROM `autoinfo` WHERE 1

result:

Audi  
Ford  
...

I need to that result:

Audi w  
Ford w  
...  

How can I do this?

Answer 1

If you need to concatenate a symbol after the brand, then use the CONCAT() function:

SELECT concat(brand, ' w') as brand
FROM `autoinfo` 
WHERE 1;