SQL search and replace question

software development

#1

I’ve recently switched my messageboard from PHPBB to Invision. I’d like to do a search & replace in the database and swap all [img] entries to [IMG] so invision will recognize the tags. Being an absolute SQL newbie, how would I do this via PHPMyadmin?