[RESOLVED] Update part of a string

[jansky]

to all guru

i have a table consist hundred of data

now i just want to update a portion of string only

eg: value
layout1_this_islayout1A
layout1_this_islayout2A
layout1_this_islayout3A
layout1_this_islayout4A

now when i update with layout2

it should be
layout2_this_islayout1A
layout2_this_islayout2A
layout2_this_islayout3A
layout2_this_islayout4A

im a little bit lost in query update
$string="layout2";
update table set field1='$layout2' (some parameter here which i dont recall anymore) where field1 like ('layout1_%');

TIA

[bradgrafelman]

Try something like:

UPDATE table SET field1=CONCAT('$layout2', SUBSTRING(field1, LOCATE('_', field1))) WHERE field1 LIKE 'layout1\_%'

[jansky]

thanks

i already solved in other way

update table set field=replace(field','layout1','layout2') where field like ('layout1_');