upgrade/0.9.14/04_newsletter.sql

   1 UPDATE newsletter_art SET body =
   2 REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(body,
   3 "[b]", "'''"),
   4 "[/b]", "'''"),
   5 "[i]", "''"),
   6 "[/i]", "''"),
   7 "[u]", "{+"),
   8 "[/u]", "+}"),
   9 "[title]", "\n!"),
  10 "[/title]", ""),
  11 "[subtitle]", "\n!!"),
  12 "[/subtitle]", "");