[SOLVED] Do I have to do PHP for this?

[The Little Guy]

I would like to append text to the end of a string in the database.

 

For example:

 

If a cell has this text in it: "I am a string" and I want to add something to the end of it, so the result would look like this: "I am a string and I am the addition".

 

Could I do that using MySQL instead of PHP? It would save me a query.

 

If this does work, I would assume I could do this:

 

$str = 'I am the addition';
mysql_query("UPDATE table SET column = (column + '$str') WHERE id = '1'");

 

Would I be correct or not?

[Prismatic]

Did you try it?

[PFMaBiSmAd]

It would be CONCAT() not +

 

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat

[The Little Guy]

OK cool, Thanks!

 

here was my final result:

 

mysql_query("UPDATE people SET relations = TRIM(LEADING ',' FROM (CONCAT(`relations`, '$str'))) WHERE id = '$link'");

 

Tell me if it can be improved?