UPDA PART OF STRING IN CHAR FIELD

[Anon]

I need to replace part of a string in a field with another piece of string.

Look I know it is wrong:

• In this case I didn't specified the field, but that's what I want to.
• In the example below, I think it is going to consider the whole table

UPDATE test SET REPLACE('/','/','#') WHERE description LIKE '%/%'

I need a help to construct a correct update taking in consideration an option to choose a field for replacement.

thanks

[Anon]

What database are you using?

[Anon]

Mysql is the database. I am burning my head and I didn't get it working up to now.

I would appreciate any kind of help.

Thanks

[Anon]

Well, first select the field out, then make the changes using PHP's string functions (see the manual), then update the row with the new data.

[Anon]

How about this:

$column = "description";
$change_from = "/";
$change_to "#";
$query = "UPDATE table SET $column = REPLACE($column,'$change_from','$change_to')";
$result = mysql_query($query);

I think that's what you mean...

$column, $change_from, and $change_to would be constants or set dynamically, of course.

---John Holmes...

[Anon]

this way it updates in general the whole field with a value. I need to update just a part of a string.

ex. John Holmes (changin o for x)
ex. Jxhn Hxlmes

Did you get it?

Thanks

[Anon]

It does just update part of the string. How are you attempting to do it? Here's an example from the manual:

REPLACE(str,from_str,to_str)
Returns the string str with all all occurrences of the string from_str replaced by the string to_str:

 mysql> select REPLACE('www.mysql.com', 'w', 'Ww');
         -> 'WwWwWw.mysql.com'

---John Holmes...