[platal.git] / upgrade / 1.1.1 / 11_promo_filter.sql

UPDATE  newsletter_issues
   SET  sufb_json = REPLACE(sufb_json, 'Ing.', 'Ingénieur');
UPDATE  newsletter_issues
   SET  sufb_json = REPLACE(sufb_json, 'M%', 'Master');
UPDATE  newsletter_issues
   SET  sufb_json = REPLACE(sufb_json, 'PhD', 'Doctorat');

-- vim:set syntax=mysql:
Commit	Line	Data
1ee148f0 SJ	1	UPDATE newsletter_issues
	2	SET sufb_json = REPLACE(sufb_json, 'Ing.', 'Ingénieur');
	3	UPDATE newsletter_issues
	4	SET sufb_json = REPLACE(sufb_json, 'M%', 'Master');
	5	UPDATE newsletter_issues
	6	SET sufb_json = REPLACE(sufb_json, 'PhD', 'Doctorat');
	7
	8	-- vim:set syntax=mysql: