I want to know if this syntax is correct before I try anything. I have a field with info in it all ready and I want to add a string to every entree. Is this correct syntax. if not what is. I couldn't find it in the docs.

update table set field = field + 'this is the string';


anyone??

I haven'y used MySQL before but it looks like you are
missing a WHERE clause

so:

update table set field = field + 'this is the string' WHERE field2 = 'value_here';

UPDATE {tableName} SET <col>=NewColValue WHERE <WHERE CLAUSE>

So, for example:

UPDATE articles SET totalNumb = 5 WHERE ID = 4;

www.php.net/manual
Read the user comments etc.

I haven'y used MySQL before but it looks like you are
missing a WHERE clause

You only need a where clause if you want to change one specific entree. I wanted to add a string to every one in the table so a where clause is not needed.

UPDATE {tableName} SET <col>=NewColValue WHERE <WHERE CLAUSE>

So, for example:

UPDATE articles SET totalNumb = 5 WHERE ID = 4;

That is just for updating not adding 2 strings together in an update. here is what I found so if anyone else needs it, it will not be hard to find.

update table set field = concat(field,'string',...etc); And if you need a specific entree you can add the where clause.

Thanks guys for trying.

I would suggest that you use following script :

$field1 = $field."this is the string";

update table set field = '$field1';

This will update all rows that met the criteria. To update specific rows, add in WHERE clause