how can I append a text string to each row in a column

[wright67uk]

how can I append a text string to each row in a column?

 

I have a database with several columns;

 

ID, name, product, product_id, description etc.

 

the description column is made of BLOBS.

 

I need to add the same string of text to the end of each description in my table.

 

"  </p> </p> This tree has been recently potted at the end of bare root season.  "

 

Is this possible to do using 1 sql query?

 

I only have 20 or so products in this table so I could do this manually 20 times, but I thought it would be useful to know, especially if I have to add text to a table someday with 500 products in.

[Barand]

UPDATE mytable SET description = CONCAT(description, '  </p> </p> This tree has been recently potted at the end of bare root season.  ');

[wright67uk]

Perfect, Thankyou!

 

For future reference , is this possible?

 

eg.  if later in the year I want to change

 

"  </p> </p> This tree has been recently potted at the end of bare root season.  "

to

"  </p> </p> This tree is a bare root product.  "

 

how can i search for the mentioned text string and change only that text string without effecting any text before it?

[Barand]

MySQL has a REPLACE function