Hi

I have a table which looks like this
id | name | length | clone | null
1 | string 1 | 12345643 | string 1 | NULL |
2 | string 2 | 2345612 | string 2 | NULL |
3 | string 3 | 3421556 | string 3 | NULL |
4 | string 4 | 1236742 | string 4 | NULL |
5 | string 5 | 2312677 | string 5 | NULL |
6 |string 6 | 12786315 | string 6 | NULL |
7 | string 7 | 2341135 | string 7 | NULL |
8 |string 8 | 452189 | string 8 | NULL |
9 |string 9 | 124343 | string 9 | NULL |
10 | string 10 | 3432344 | string 10 | NULL |
.....

I wanted to replace all names columns having id> 5 to sequence.
Keep the first 5 entries the same but replace all others name = "sequence[id]"
and clone entry to be changed as clone = "sequence[id]"
The table should look like this

id | name | length | clone | null
1 | string 1 | 12345643 | string 1 | NULL |
2 | string 2 | 2345612 | string 2 | NULL |
3 | string 3 | 3421556 | string 3 | NULL |
4 | string 4 | 1236742 | string 4 | NULL |
5 | string 5 | 2312677 | string 5 | NULL |
6 |sequence 6 | 12786315 | sequence 6 | NULL |
7 | sequence 7 | 2341135 | sequence 7 | NULL |
8 |sequence 8 | 452189 | sequence 8 | NULL |
9 |sequence 9 | 124343 | sequence 9 | NULL |
10 | sequence 10 | 3432344 | sequence 10 | NULL |



i did use this command
UPDATE tablename
SET name = "sequence[id]"
where id >5;

but it didnt work

What is the error I did?

Try this - note it includes space between sequence and id in new values as your "after" example showed.

Thanks it worked!