Insert some text after last character in a SQL string

Databases
1

Hi,
I have a table like this:

id | name
+++++++++
1 | ab
2 | bq
3 | g
4 | qaa
5 | e

I’d like to add “11” after the last character for each row in a column. So I need it to be:

id | name
+++++++++
1 | ab11
2 | bq11
3 | g11
4 | qaa11
5 | e11

I tried: "UPDATE table SET name=name+‘11’ , but that doesnt work.

Is there a way to accomplish this?

2

Ah, I have done it when i try UPDATE TABLE SET name =concat(name, ‘11’).

3

name+‘11’ is sql server syntax, concat(name,‘11’) is mysql syntax

you need to tell us which database you’re using when you ask a question

:slight_smile: