mysql search and replace
Posted: Thu Jan 22, 2004 1:12 am
i want to do a search and replace in mysql. what is the method for that?
Select
FROM members
WHERE 1 AND local_icon = "icons/.gif"
i want to replace "icons/.gif" and with "" (i.e. delete some bad icon locations)
Select
FROM members
WHERE 1 AND local_icon = "icons/.gif"
i want to replace "icons/.gif" and with "" (i.e. delete some bad icon locations)