SQL UPDATE add values in a field / column

Question

Here is what I want to do:

current table:

+----+-------------+
| id | data |
+----+-------------+
| 1 | cow cow2 |
| 2 | cat cat2 |
| 3 | cam cam2 |
| 4 | cal cal |
+----+-------------+

here is what I want

+----+-------------+
| id | data |
+----+-------------+
| 1 | cow a cow2 |
| 2 | cat a cat2 |
| 3 | cam a cam2 |
| 4 | cal a cal |
+----+-------------+

thats it! I just want to add one little word between 2 already existing in my databases tables and wonder how this can be done?

@EdT.: This posting is not on concat, but replace or something like that. — Ravinder Reddy
– Ravinder Reddy, Commented Mar 29, 2014 at 13:32

AgRizzo · Accepted Answer · 2014-03-29 13:33:58Z

2

you can simply replace the space character with a space, the letter a and another space

UPDATE foo
SET data = REPLACE(data, ' ', ' a ');

answered Mar 29, 2014 at 13:33

AgRizzo

5,2711 gold badge15 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ravinder Reddy Over a year ago

Hope for the data having a single space.

user2406918 Over a year ago

Hey, my misstade. The data do not have a single space always, sometimes it's 2 or 3. anyway i can decide for each run wich space i want to insert my new data? the first second or third etc.

Bellash · Accepted Answer · 2014-03-29 13:36:20Z

0

Use the Replace function

    UPDATE tableName
   SET data = REPLACE(data, ' ', 'a')

answered Mar 29, 2014 at 13:36

Bellash

8,2776 gold badges57 silver badges95 bronze badges

1 Comment

user2406918 Over a year ago

Hey, my misstade. The data do not have a single space always, sometimes it's 2 or 3. anyway i can decide for each run wich space i want to insert my new data? the first second or third etc

Collectives™ on Stack Overflow

SQL UPDATE add values in a field / column

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related