[Koha] MySQL to update dateaccessioned

[Paul]

Apologies - solved. One of those days that the KISS principle didn't kick 
in. The REPLACE in line 2 is not needed and the line should read: SET 
items.dateaccessioned='2010-12-31'

Paul

At 06:03 PM 11/22/2012 -0500, I wrote:
>I am trying to update a bunch of various dates to 31 Dec. The following 
>appears to be syntactically OK, finds all 1302 to be changed, but does not 
>change them to 31 Dec.
>
>mysql> UPDATE items
>-> SET items.dateaccessioned=REPLACE(items.dateaccessioned,'%','2011-12-31')
>-> WHERE blah blah blah;
>Query OK, 0 rows affected (0.04 sec)
>Rows matched: 1302 Changed: 0 Warnings: 0
>
>Help really appreciated ...
>
>Many thanks - Paul