On the board I'm running, I have two of these icons: []
https://www.ubbdev.com/forum/images/icons/book.gif[/]
One is book.gif and the other is note.gif. Instead of having both of these icons be the same, I'd like to get rid of note.gif.
I'd have to update all the old posts who's topic icon is note.gif and replace them with book.gif.
Anyone know the syntax for this?
I'm using 6.1.1 and my tables start with w3t
*EDIT*
UPDATE w3t_Posts SET B_Icon = 'book.gif' WHERE B_Icon='note.gif';
Is that it? I want to make sure before I run it.