From 21219c8fb21925458c5c5c2e3eb5b4ecf6ea6a02 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 6 Mar 2019 16:09:06 -0300 Subject: [PATCH] Bug 21953: Update existing rows in DB Signed-off-by: Hayley Mapley Test plan passes. Signed-off-by: Martin Renvoize --- installer/data/mysql/atomicupdate/bug_21953.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 installer/data/mysql/atomicupdate/bug_21953.sql diff --git a/installer/data/mysql/atomicupdate/bug_21953.sql b/installer/data/mysql/atomicupdate/bug_21953.sql new file mode 100644 index 0000000000..8a18635bd6 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_21953.sql @@ -0,0 +1 @@ +UPDATE accountlines SET description=REGEXP_REPLACE(description, '^Lost Item ', '') WHERE accounttype="PF"; -- 2.20.1