Unannounce announcements.

MK1

I've just imported my database from phpbb. Because the previous phpbb forum had many categories, and had quite a few announcements in each category now the top half of my vanilla forum is only showing announcements.

is there a nice easy database query to convert these announcements to normal posts...

thanks

luc

GDN_Discussion has an Announce column set to 1 for those, set it to 0.