[platal.git] / upgrade / 0.9.14 / 04_newsletter.sql

UPDATE newsletter_art SET body =
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(body,
"[b]", "'''"),
"[/b]", "'''"),
"[i]", "''"),
"[/i]", "''"),
"[u]", "{+"),
"[/u]", "+}"),
"[title]", "\n!"),
"[/title]", ""),
"[subtitle]", "\n!!"),
"[/subtitle]", "");
Commit	Line	Data
	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]", "");