mysql update without replacing existing data

Question

I need to update a row in my mysql database, but i don't want to replace the data that is already stored in it. example:

select books from storedb where id='Rick';

result of the query: Books = "example1"

but i need to update that row and add more books.

update storedb set books='example2' where id='Rick';

but it replaces the current data, so i need to do it without replacing current data. somethink like this: books='example1 -- example2";

Florian · Accepted Answer · 2014-09-03 23:53:42Z

up vote -1 down vote accepted

so you need a string concatenation? Try this:

update storedb set books=CONCAT(books,' -- ', 'example2') where id='Rick';

answered 2 hours ago

Florian
2411

Thanks a lot, it worked!. – OverHead 2 hours ago

No problem, could you please accept this answer then? Thanks – Florian 1 hour ago

add a comment |

1 Answer 1