From 412ffd95967e869449f3dd5ebae651fee3624c5e Mon Sep 17 00:00:00 2001 From: olivier Date: Wed, 15 Apr 2009 13:04:52 +0000 Subject: [PATCH] mucem import: remove line breaks from titles git-svn-id: http://svn.parisson.org/svn/crem@77 3bf09e05-f825-4182-b9bc-eedd7160adf0 --- trunk/import/prototype/scripts/mucem-import.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/trunk/import/prototype/scripts/mucem-import.sql b/trunk/import/prototype/scripts/mucem-import.sql index ab63743..9e7cfef 100644 --- a/trunk/import/prototype/scripts/mucem-import.sql +++ b/trunk/import/prototype/scripts/mucem-import.sql @@ -30,6 +30,7 @@ SELECT f1, f2, f3, f4, f5, f6, f7, f8, CONCAT_WS(' - ', f46, f9, f43), f10, f11, f12, f13, f14, f16, f17, f18, f19, f20, f22, f23, f24, f25, f26, f27, f28, f29, f30, "", f31, 'items/test.wav' FROM mucem_import; UPDATE telemeta_item SET continent = UPPER(continent); +UPDATE telemeta_item SET title = REPLACE(title, '\n', ' - '); DELETE FROM telemeta_collection; INSERT INTO telemeta_collection (physical_format, id, title, physical_items_num, -- 2.39.5