Member Avatar for 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--?

  • 2 Contributors
  • 5 Replies
  • 143 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by Stardemos
Member Avatar for pritaeas

Use CONCAT.

Member Avatar for Stardemos

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

Member Avatar for 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.

Member Avatar for pritaeas 
SELECT CONCAT(aa, '--') AS aa FROM yourtable
Member Avatar for Stardemos

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

THANKS

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.