Posted By

iroybot on 09/22/09

Tagged

replace
update

Versions (?)

Last Edited at 09/22/09 09:11am

Statistics

Viewed 865 times

Favorited by 1 user(s)

Related snippets

Conditional String Replace

/ Published in: MySQL

as a note to self... in order to find it laters...

This will only alter the value of fieldname if the conditions in the WHERE clause are met. With replace we only replace a certain string within fieldname with the replace_with string

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

UPDATE `table` SET `table`.`fieldname` = replace(`fieldname`, 'search_value', 'replace_with') 
WHERE `table`.`firstcondition_field` = 'firstcondition_value'
AND `table`.`secondcondition_field` = 'secondcondition_value'
AND so on...