On the board I'm running, I have two of these icons: []http://www.ubbdev.com/forum/images/icons/book.gif[/] <br />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. <br /> <br />I'd have to update all the old posts who's topic icon is note.gif and replace them with book.gif. <br /> <br />Anyone know the syntax for this? <br />I'm using 6.1.1 and my tables start with w3t <br /> <br />*EDIT* <br />UPDATE w3t_Posts SET B_Icon = 'book.gif' WHERE B_Icon='note.gif'; <br /> <br />Is that it? I want to make sure before I run it.
Edited by chiefmonkey (04/18/03 03:01 PM)