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)
mysql search and replace
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Use an UPDATE query:
Mac
Code: Select all
UPDATE members SET local_icon='' WHERE local_icon='icons/.gif'