Query to add "--" in the end of all fields in one column?

[Stardemos]

i need a querry to add -- in the end of a table. for example if i have a table like

tb name ze

   ad|ID|   aa  |
    --------------
    01|02|aa01   |
    02|03|aa02   |

how do i add -- to the end of all fields of aa column to be like aa01--\aa02--?

[pritaeas]

Use CONCAT.

[Stardemos]

thanks, i'll try it, if i cannot do it wright, i'll ask for help again

[Stardemos]

or i did not understand the concat function or it just dont do what i need

as far as i understod, concat function output the table contens plus the separator,
what i need is to add in the table content the "--" in the end of all the column.

[pritaeas]

SELECT CONCAT(aa, '--') AS aa FROM yourtable

[Stardemos]

thanks, i've found a way earlier, just fotgot to post it... after driking another coffe i finaly understand it.

THANKS