Mysql - Sql update question

[kschuster]

I a TEXT column that needs a word appended to it's contents - if any - based on a specific found set.

Is there a way to do this in mysql?

[sledgeweb]

Use select to get your data.

Test the result to see if it needs text added.

$data = mssql_result($result, $i, 'tableName');
if ($data == "whatever")
{
$data .= " new text on end";
}

If you updated the data, update your table with the new data.

[kschuster]

You can do this kind of operation with a sql statement?

I can see doing that in php but can this be done with pure sql - is there a way?

[sledgeweb]

That was using php with SQL, um, just using SQL, I think you can do something like:

UPDATE table SET fieldName = fieldName + ' new text' WHERE condition

I know that works for MSSQL. Not sure if it works for MySQL, but give it a try (may need to use period instead of plus). Also, look up MySQL's CONCAT function.

[Drakla]

Yarrr, the name=name+" something" be leadin to a whole world o'hurt in MySQL, indeed the path of the righteous man be strewn with CONCAT of the form:

UPDATE worzel set name=CONCAT(name," AUNT Sally") WHERE somethingorother;